SQL 2012

Interview with Warwick Rudd

Interview with Warwick Rudd

  Part of traveling to various events and being a part of the SQL Community means one can meet some pretty awesome professionals. I was fortunate enough to run into Warwick Rudd (B|T) at one of the PASS Summit events held in Seattle, and he definitely lives up to all the hype. Warwick is a […]

Reports In SSISDB

I was approached with an in shop issue where a group could not view the execution reports in the SSISDB. The reason for this was due to the security standards in place at the shop; the user could not be allowed to have the SSIS_Admin role. In order to allow the user group access to […]

Why is Count(*) Taking So Long

Phone rings……..I answer…….a DBA from a third party vendor has supplied someone with two scripts. The first script is a simple insert with a where clause: insert into [databasename].[dbo].[tablename] ( column1,column2, column3, column4 ) select column1, column2, column3, column4 from [databasename].[dbo].[tablename] where column1<[integeramount] and column1>[integeramount] First question I ask; how much data is loading into […]

PowerShell Tactics

Last months T-SQL Tuesday party dealt with PowerShell. I debated on whether or not to post a topic, but in the end I didn’t feel like I should post something that I had not really ever tried before so I spent a few weeks going through some basic power shell scripting and what I ended up […]

Select * Syndrome

Something that I have seen lately over and over again and even ran into this morning is a practice that I would say is a pretty bad habit in SQL….the dreaded Select * syndrome This method is heavily used for adhoc querying and I’ve seen it used in some troubleshooting scenarios but in my case […]

Microsoft SQL Server 2012 SP1 Release

I’m a little behind in getting this information out; I wish I could say it was because I was in Seattle last week for the PASS Summit 2012; however that was not the case. In any sense Microsoft has released Service Pack 1 for SQL Server 2012. The last list of fixes I saw for what […]

SQL Server 2012 Best Practices – The Book

 People who I have spoken with over a period of time know that I have dubbed this as “The Book“. There are several reasons why I am stoked to get my hands on a copy of this book (should be in transit to me as I type!), but one of the main reasons is I […]