Comments Feed

SQL Server Data Tools for SQL Server 2014 Commented on: 2 years ago (December 15, 2014)

I agree with Michael 100% on this one. It has taken me several Google searches just to find out the name of the product, and three visits to Microsoft's website to find the correct download. For...

T-SQL 101, Lesson 1 Commented on: 4 years ago (September 20, 2013)

That looks to be a typo. There should definitely be '=" in both cases.

T-SQL 101: Views Commented on: 4 years ago (September 20, 2013)

You can grant read access to a view while revoking access to the base table. Updatable views however, require update access to the base tables.

Are You a SQL Server Master? Commented on: 9 years ago (July 17, 2008) Interesting article...but when it comes to certifications I don't value them too highly. Sadly, I have worked with people who have have studied and studied to pass their Microsoft SQL Server...
How Sun's Acquisition of MySQL Will Affect SQL Server Commented on: 9 years ago (April 24, 2008) I have been using MySQL for a year now as a database back end for various websites I operate. Although I am much more familiar with SQL Server (13 years!) I really do appreciate what you can do with...
Stored Procedure Documents Scheduled Jobs in SQL Server Commented on: 9 years ago (March 4, 2008) Bvnashok, This stored procedure has been tested on a variety of SQL Server installations and has been running without error for years (the original code was developed in 2002 for SQL 2000). Can you...
How Many's Too Many? Commented on: 10 years ago (April 17, 2007) Loved the article! I have used the super/sub relationships many times without knowing there was an actual official terminology.
SQL Server Wishes Can Come True Commented on: 10 years ago (January 11, 2007) Here is my gripe: I like to view results in a grid, using fixed width font like courier new. In ManagermentStudio, however, when the data gets just a bit wider than some magic pre-defined setting...
Prove That the Database Isn't to Blame Commented on: 11 years ago (September 29, 2006) I just used this proc to show how every time a user was hitting a particular button on the app, the server start to grind. Pushing the button caused a script to run that updated every ID in a table...
Stored Procedure Searches for Strings Commented on: 11 years ago (July 24, 2006) Hey, this is pretty neat. It is like "grep" for SQL.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Jul 17, 2017

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×