|
Category: Uncategorized
#TSQL2SDAY (8) Administration (41) AI (2) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-
October Updates – SQL Server 2012 RTM CU #10
/
SQL Server 2012 RTM Cumulative Update #10 is now available. KB Article: KB #2891666. Build Number is 11.0.2420. Applicable to @@VERSION 11.0.2100 through 11.0.2419. NOTE:…
-
Optimizing the BACKUP Command
/
One challenge for a DBA is to setup the appropriate backup plans for the databases under our responsibility. It is easy to use SSMS’s…
-
T-SQL Command Line Options – Part 3 – PS w/ .NET
/
Powershell and .NET Objects Now that we’ve covered SQLCMD.exe with the command prompt I’d like to dive into the present and future of Windows…
-
Temporary Stored Procedures
/
We are all familiar with table variables, local temp tables, and global temp tables but what some people over look is that stored procedures…
-
The Peter Principle
/
The Peter Principle The Peter Principle, as referenced above, is, “the theory that employees within an organization will advance to their highest level of…
-
Unattended (Silent) SQL Server Installations
/
As promised from my last post, Relocating SQL Server System Databases without Access to the Instance, today I will be blogging about ‘unattended’ or…
-
T-SQL Command Line Options – Part 1
/
Every SQL Server DBA is intimately familiar with SQL Server Management Studio (SSMS) and/or previous tools such as Query Analyzer. What some of us…
-
Creating Logins and Users – Why I can’t connect
/
If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly…
-
Free SQL Tools
/
Below is a collection of free tools every DBA should know about. Plan Explorer Apex SQL sp_Blitz sp_BlitzIndex sp_WhoIsActive Index Defrag Script 4.1 SQL…
-
July SQL Server Updates
/
July Updates for SQL Server SQL Server 2012 Service Pack 1 Cumulative Update #5 is now available. KB Article: KB #2861107. Build Number is 11.0.3373. Applicable…