sqladm.blogspot.com

SQLAdmin: 2013-01

http://sqladm.blogspot.com/2013_01_01_archive.html

SQL Server administration, infrastructure, automation, instrumentation etc. Call command-line in PowerShell. Often I have to build a command-line statement dynamic and then execute the statement. The PowerShell call operator (&) can be cumbersome to use, but following some simple rules or using a general template can do the trick. This operator is also called the invoke operator. In general the trick is to call the command with the operator and put parameters in an additional array. Cmd = '.exe'. By putt...

SQLAdmin: 2014-09

http://sqladm.blogspot.com/2014_09_01_archive.html

SQL Server administration, infrastructure, automation, instrumentation etc. With the roll-out of the Security Bulletin MS14-044. I found out the hard way that the DBA Repository ( SQLAdmin. Repository) did not have the new version numbers. 1005520 for SQL Server 2008 SP3. 10504033 for SQL Server 2008 R2 SP2. 1103153 for SQL Server 2012 SP1. 1202254 for SQL Server 2014. When the data were inserted, the automation ran with success. It looks like the Security Update only affect SP1 of SQL Server 2012. The a...

SQLAdmin: 2014-03

http://sqladm.blogspot.com/2014_03_01_archive.html

SQL Server administration, infrastructure, automation, instrumentation etc. I am working on an automated SQL Server installation, where we use Managed Serviece Accounts. MSA) as SQL Server service account. To create and configure a MSA some PowerShell CmdLets are given by Microsoft, but there are several steps each with it own CmdLets. Parameter(Mandatory=$true, HelpMessage='Enter name of server. Use Fully Qualified Name (FQN), e.g. "SANDBOX.sqladmin.lan"')]. Computername' does not exist in DNS as FQDN!

SQLAdmin: 2014-10

http://sqladm.blogspot.com/2014_10_01_archive.html

SQL Server administration, infrastructure, automation, instrumentation etc. DBCC CHECKDB with PowerShell. T-SQL) is really great for many things inside the SQL Server Database Engine, but automated maintenance with file handling, logging and other nice things is more of a challenge. This is why I and other fellow DBAs use PowerShell. A standard DBA task is to check the databases, also their integrity with the console command DBCC CHECKDB. Service Broker Msg 9675, State 1: Message Types analyzed: 14.

SQLAdmin: 2013-09

http://sqladm.blogspot.com/2013_09_01_archive.html

SQL Server administration, infrastructure, automation, instrumentation etc. Xp instance regwrite syntax. The stored procedure "master.sys.xp instance regwrite" is not documented in SQL Server Books Online (BOL), but is usefull. In general the syntax is. EXECUTE [master].[sys].[xp instance regwrite]. Rootkey = N' name of root key '. Key = N' key name '. Value name = N' key name value '. Type = N' key type '. Value = N' key value ';. EXECUTE [master].[sys].[xp instance regwrite]. Type = N'REG DWORD'. MsSql...