SQLskills SQL101: Stored Procedures
Sometimes going back-to-the-basics is the best thing to do to fully understand something. Some of us have been doing things in a certain way for
Sometimes going back-to-the-basics is the best thing to do to fully understand something. Some of us have been doing things in a certain way for
In Nov 2014, SQLskills made an offer to user group leaders to deliver remote user group sessions in 2015 and we’ve been having great fun delivering
I’m not sure about how to title this OR how to avoid the term “it depends” but I also don’t feel that “it depends” is
[NOTE: Update 12 Nov 2014. The most recent bug (KB article KB2965069) is THANKFULLY very unlikely for most environments (mentioned below). As a result, I’m glad
I’ve been seeing this over the past few years, imagine this scenario: You have a stored procedure that runs well most of the time but
Last week I visited the .Net User Group in NY where .NetRocks was recording as part of their Visual Studio Road Trip… What a great
OK, I've had a bit of a tangent going on optimizing stored procedures and its all revolved around adhoc plan caching and potentially wasted cache
In my post describing the new SQL Server 2008 configuration option [optimize for adhoc workloads] titled: Plan cache and optimizing for adhoc workloads, I asked
I mentioned that servers receiving a lot of dynamic constructs (typically those generated by client SQL apps/ORMs/LINQ, etc.) can start to consume too much plan
Stored procedures aren’t always a favorite choice from developers. And, to add to the confusion, there are numerous ways that a client application can make
I started this series with the post titled: Little Bobby Tables, SQL Injection and EXECUTE AS. I then moved to discussing some of the differences
In my last post: Little Bobby Tables, SQL Injection and EXECUTE AS, I wanted to highlight how to avoid SQL Injection when using EXEC. A few
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.