SQL Server 2012 FileTable – Part 1
In a series of blog posts we will have a look at the new SQL Server 2012 table type called...
2012-01-06 (first published: 2012-01-03)
4,924 reads
Danish Developer Conference – DDC 2012
I am proud to announce that we at Geniiius will be speaking at DDC 2012. DDC 2012 is a one...
2011-12-29
1,680 reads
SQL Server 2012 – new conversion functions
With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...
2011-12-20
1,189 reads
SQL server 2012 Startup parameters
I’m sure that I’m not the only one with nightmares about the startup parameters in older versions of SQL Server...
2011-12-06
1,170 reads
CONCAT() – SQL Server 2012
With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of...
2011-11-29
1,069 reads
SQL Server trace flags
Normally I’m not a big fan of using traceflags, my advice is only to use these when it is absolutely...
2011-11-22
2,348 reads
SQL Server ® 2012 Release Candidate (RC0)
Finally it is here, the SQL Server 2012 RC0 is ready for download, click this link and you’ll be downloading...
2011-11-18
759 reads
SQL Server 2012 licensing
Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008,...
2011-11-14
949 reads
How much space are you wasting?
A few weeks back a client of mine asked me to write a script that could tell him the space...
2011-11-08
854 reads
Backup/restore/checkdb/shrinkfile progress
Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you...
2011-11-01
1,112 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