Tag Archives: MSSQL

… and one more thing … about Managed Service Accounts

Posted on April 18, 2012 by Jiří Hubáček

Microsoft released hotfix for Windows Server 2008 R2 and Windows 7 fixing password change mechanism. MSA’s passwords are updated by default every 30 days (may be changed in registry at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NetLogon\Parameters). When password expires and is changed by computer, Kerberos … Continue reading →

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged 2012, Managed Service Accounts, microsoft sql server, Microsoft SQL Server 2012, MS SQL 2012, MSA, MSSQL, MSSQL 2012, new features | Leave a comment

Managed Service Accounts with Microsoft SQL Server 2012

Posted on April 16, 2012 by Jiří Hubáček

Managed Service Accounts (MSA) which came with Microsoft Windows Server 2008 R2 and Windows 7 allow you to create domain account which is tied to a specific computer. The account itself is a hybrid of User and Computer account and … Continue reading →

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged Managed Service Accounts, microsoft sql server, Microsoft SQL Server 2012, MS SQL 2012, MSA, MSSQL, MSSQL 2012, new features, powershell, Windows Server 2008 R2 | 41 Comments

Microsoft SQL Server Myth #1

Posted on April 8, 2012 by Jiří Hubáček

Full backup clears the transaction log which may be shrunk afterwards. FALSE

Posted in Microsoft SQL Server Myths | Tagged microsoft sql server, MSSQL, myths | Leave a comment

Microsoft SQL Server Myths category

Posted on April 5, 2012 by Jiří Hubáček

Hello again! In this section I would like to share some of the myths I come across at my day to day activities. In my opinion myths may be divided into three categories by their origin. 1. Incomprehension 2. Ignorance … Continue reading →

Posted in Microsoft SQL Server Myths | Tagged microsoft sql server, MSSQL, myths | Leave a comment

Iterate through all databases / tables. Is sp_MSforeachdb good idea?

Posted on March 28, 2012 by Jiří Hubáček

Ever heard of sp_MSforeachdb or sp_MSforeachtable procedures which iterates through all databases or tables? Well you might not because they are undocumented procedures about which Microsoft says are for internal use only and might not work for all scenarios. Also … Continue reading →

Posted in Microsoft SQL Server | Tagged microsoft sql server, MSSQL, sp_MSforeachdb, sp_MSforeachtable, T-SQL, Undocumented procedures | Leave a comment

Free e-book: Introducing Microsoft SQL Server 2012

Posted on March 19, 2012 by Jiří Hubáček

Today I have come across free e-book Introducing Microsoft SQL Server 2012. Book introduces you into new features of 2012 like High Availability and Disaster Recovery, Security, Integration Services, Data Quality Services, Master Data Services, etc. … Here is the … Continue reading →

Posted in Microsoft SQL Server | Tagged 2012, e-book, ebook, Microsoft SQL Server 2012, MS SQL 2012, MSSQL, MSSQL 2012, new features | Leave a comment

Is it possible to run Integration Services 2008 R2 against MSDB at 2005 instance?

Posted on March 11, 2012 by Jiří Hubáček

Last week I was asked by my colleague whether Integration Services 2008R2 can run against MSDB database located at Microsoft SQL 2005. At first I was in belief it was possible because I remembered article in MSDN library which said: