The week that was: Friday 15th July 2010
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
644 reads
Gethyn Ellis
TSQL2sday #008 – Gettin’ Schooled
This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here....
2010-07-13
800 reads
SSIS - Enabling Logging
Have you ever had a scheduled run of one of your SSIS packages fail? Have you ever wished you had...
2010-07-12
2,041 reads
SQL Server Agent – Proxy error
I was setting up some SQL Server agent jobs in a test environment. I needed one of our testers to...
2010-07-09
14,313 reads
SQL Bits 7 – The 7 wonders of SQL
I have been procrastinating this evening, I have several blog posts that I want to write but the football is...
2010-07-08
593 reads
DB2 – Create a Database
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
4,973 reads
2010-06-28
676 reads
Lock Pages in Memory
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,649 reads
24 Hours of PASS
On the 19th/20th May (last month) the Professional Association of SQL Server (PASS) held its second 24 hours of PASS...
2010-06-23
723 reads
Windows 2008 R2 Install Error - Using VMWare Workstation
Recently I was installing Windows Server 2008 R2 Enterprise Edition onto a virtual machine (VM) I was setting up to...
2010-06-22
2,308 reads
Blogs
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...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
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