Overview of Published Articles – 2014Q1
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an...
2014-04-15
493 reads
Blog Posts
Parallel Data Warehouse (PDW) AU1 released
Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason...
2014-04-15
1,376 reads
PASS SQLSaturday Events: May 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-04-15
492 reads
Rounding versus truncating
Be careful when implicitly converting data types in T-SQL. Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to...
2014-04-15
1,045 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-15 (first published: 2014-04-07)
3,306 reads
SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...
2014-04-15
1,988 reads
SQL Server First Aid
If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you...
2014-04-15
1,116 reads
SQLServerCentral Editorial: Doing What It Takes To Get The Job Done
I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to...
2014-04-15
438 reads
Why a Boot Camp?
As a some of you may already know, I am now offering SQL Server boot camps with the first one...
2014-04-15
1,351 reads
Writing a Question Of The Day–More Notes
Today I wrote another question based on an error message. I included the error message in the question this time...
2014-04-15
485 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers