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... Continue Reading →

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... Continue Reading →

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... Continue Reading →

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... Continue Reading →

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... Continue Reading →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: