Scheduling Tools I wrote about scheduling in Azure yesterday as a place where some of the tools we have become accustom are not available. My primary tool of choice for scheduling has been SQL Server Agent, being primarily a DBA for decades. One reader, Shannon, reminds us that there are a lot of capabilities built into Azure allowing for tasks […]
Tag: tde
Precision and Conversion
$$SWYNK$$ Featured Article(s) How Do You Transition from a Consulting Job Back to Management? I recently received a question regarding “How do you transition from a consulting job back into management?” This is a great topic, because the answer is useful whether you are moving from a consulting job back into IT, or management; OR moving from any field to […]
Is it Time for ORMs?
SSWUGtv With Stephen Wynkoop On the show today we have Kevin Kline as he shares his thoughts on why Big Data is important Watch the Show Is it Time for ORMs? Object Relational Mapping tools have been around for years, and are still a controversial issue. Coming from a DBA background I find them to be both a friend and […]
SQL Azure Federations
SQL Azure Federations One of the coolest features in SQL Azure is Database Federations. Federations allow you to grow the power and size of your database in SQL Azure to an much larger scale than the largest single database allowed of 150Gig. For an overview of SQL Azure federations you can watch this into video from Microsoft demonstrating what Federations […]
SQL Server 2012 Released
SQL Server 2012 Released Microsoft announced the release of SQL Server 2012.What’s in it? How to I get up to speed with this Release? Check out the link for more information. Microsoft Says, Customers can download the latest version of SQL Server 2012 here . Also, for a deep dive on all things SQL Server 2012, check out the SQL […]
Modern Documentation
Featured White Paper(s) Encryption & Key Management for Microsoft SQL Server 2008 Written by Townsend Security Simplify encryption and key management on … (read more) Featured Script convert_ident_to_guid.sql Script to find all ident columns in db, find out if they are in an index, (if so)drop the index, recreate the ident as guid, … (read more) Modern Documentation We had […]
Code Naming Conventions
Reader Response – DB Naming Conventions Paul Writes: A couple of observations, based on the discussion so far. For me, some things that give me some initial pointers: – How does it look ‘out of the box’ ? – What does MS do? – What happens when you use the visual tools? – How do we avoid valueless annotation? For […]
Naming Conventions ? Primay and Foreign Keys
Naming Conventions – Primay and Foreign Keys Hank writes in with a scenario revolving around system assigned key names. In Microsoft SQL Server you can declare constraints without providing names. In these situations, the system assigns a name on your behalf, usually part of the key looking like a GUID. There is little meaning or value in the name. The […]
Editorial Thoughts for Today
Error Handling Final Comments Today I’m Wrapping up this series on error handling with some interesting insights from two of our readers. One is from an SQL Server perspective, and the other reflects code in all layers. Fraser Responds to Error Handling flow with the following thoughts: > Start at the highest level of code when handling errors. Personally I […]
Merge Comments
Merge Comments Today I had a number of comments regarding an SQL merge process. Jason: If you do the update first you have X rows in the table that it has to evaluate to join on. Now when you delete you still have X rows to join on. I believe you said you do the insert after the update so […]