microsoft sql
Migrating Databases to Azure
When converting a database from an older version of Microsoft SQL to Azure, there will be many gotchas along the way. I'd like to help you learn from the
microsoft sql
Filed under: Microsoft SQL
ToyboxCreations SELECT * FROM [My Life]
When converting a database from an older version of Microsoft SQL to Azure, there will be many gotchas along the way. I'd like to help you learn from the
microsoft sql
Converting VARCHAR to DATETIME
Recently a post was made on LinkedIn asking how one would convert a date stored in a VARCHAR field could be converted to a DATETIME so date math could be
microsoft sql
SQL Injection License Plate
While it would be nice to put my knowledge of SQL to work in such a way, I highly doubt this injection attack would do much to prevent getting a
SQL201
UNION, INTERSECT, and EXCEPT
Earlier today I was discussing methods you can use to differences in data sets between two tables or views. My colleague was discussing the usual
microsoft sql
Could my Stored Procedure cause Performance Issues?
Problem originally posted at experts-exchange. I have 3 major stored procedures, meaning they are the backbone of my application. I built them to be as dynamic
SQL301
SQL 301 – GROUPING
In our previous lesson we covered WITH ROLLUP and WITH CUBE. During that lesson you may have noticed that when we saw the summary rows, the columns had NULL as
SQL301
SQL 301 — WITH CUBE and ROLLUP
Have you been asked to summarize some data into a nice report for management? They want to see subtotals and grand totals you say? You don't have to drop the
microsoft sql
Sample Databases for SQL Azure
Ready to head into the clouds and try your hand at a version of SQL quite different from those you know today? Sign up for a SQL Azure account, then grab this
microsoft sql
Sample Databases for SQL 2008
Now that many of us are upgrading to SQL 2008, we need a new sample database. If you've obtained a copy of SQL 2008 Developer Edition, if not, check out Amazon!
microsoft sql
Sample Databases for R2
..or as I call him, Ar-too. In case you haven't heard, SQL 2008 R2 has been released as a preview. If you have downloaded it, and are looking for a sample
SQL201
Find Stored Procedures Referencing…
Time and time again, I find myself trying to find all the stored procedures that reference a specific database object. It usually comes around when I'm working