Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
The Baker's Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
SQL Server 2008 gets new developer features, and SQL Server 2008 Reporting Services gets a facelift and new architecture that no longer requires Internet Information Services.
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
The FILESTREAM Data Type in SQL Server 2008
There is a new data type in SQL Server 2008 that might help you deal with all those music, image, and other media files in SQL Server. FILESTREAM allows you to store these files in the file system, but access them from within SQL Server. New author Deepa Gheewala brings us a look at setting a table for FILESTREAM.
Changing the default SQL Server backup folder
Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?
Faking Arrays in Transact SQL
It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
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