SQL Server Security – Database Roles

Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level. If you are familiar with any aspect of system administration, database roles are similar to groups in the world of Windows system administration. Just like a Windows group, when a user is…
Read More

Links for the week of 2008-12-26

SQL SERVER Best practices for taking on the DBA role as a developer – Armando Pratocovers the basics of what it takes to go from developer to DBA. This is a good article and one that’s very near and dear to my heart since I’m pulling myself away from the development world and into the…
Read More

Links for the Week 2008-12-19

SQL SERVER Cloud Computing and me – TJay Belt delivers the best look at cloud computing that I’ve read yet. Some interesting affects of Table Partitioning – Kent Tegels discusses some interest side effects of partitioning tables and indexes. The N pillars of a well built database? – Louis Davidson is in the process of…
Read More

My Firsts

I stole this from TJay Belt. It seemed like a nice change of pace from the SQL shenanigans to 1. Who was your FIRST prom date? Didn’t go to prom (they don’t have them in Scotland), but I went to my high school dance with a girl named Ashley. 2. Do you still talk to…
Read More

Links for the Week

SQL SERVER Amazon Launches Public Data Sets To Ease Research – Michael Arrington (via TechCrunch) outlines the new data sets that Amazon is bringing to the public. This is monumental for a couple of reasons. This data is going to be freely available to anyone and everyone. This alone will add considerable value to many…
Read More

Links for the Week

Things I found interesting this week (only two days late). GENERAL The Leonardo da Vinci Guide To Being A Renaissance Man – Dumb Little Man is always good for helpful tips, but this is a great guide to tapping into your natural curiosity and drive and taking it to the next level. I have to…
Read More

A Quick Introduction to Common Table Expressions

Before diving into how to go about using a common table expression, let’s take a look at what a common table expression is and why you would want to use one. The What and Why of Common Table Expressions Essentially, a common table expression (CTE) is a temporary result set. In this regard, a CTE…
Read More

Get a Table of Months Between Two Dates

Sometimes you need a list of months between two dates. Admittedly, this is another case where a calendar table would come in VERY handy. Unfortunately, I have not been able to build one yet. In case you’re in a similar situation, here’s how you could go about doing this: CREATE FUNCTION dbo.GetMonthList ( @StartDate DATETIME,…
Read More

Links for the Week

SQL SERVER Anatomy of a Deadlock – Jonathan Kehayias outlines how deadlocks can occur, even in scenarios where they seemingly shouldn’t occur. I answered a question about this several weeks ago, but I couldn’t determine what the underlying cause of the deadlock was, I did not realize at the time that a SELECT would issue…
Read More

Loading Data… Oops, I Broke the Database

How many of you have had to load a massive quantity of data from other tables in the same database? How many of you have manage to fill up TEMPDB in the process? I encountered both of these scenarios yesterday. 31 million rows is not a tiny amount of data, by any stretch of the…
Read More
Menu