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
643 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
799 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,040 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,312 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
592 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,972 reads
2010-06-28
675 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,648 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,307 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers