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,886 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,674 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,175 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,160 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,060 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,331 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
749 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
935 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
845 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,088 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need help on query within 2 column, generate another column
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
SELECT blocking DML and DDL
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
query filling up tempdb
Hi All, Need some help in tune a function which is reading TB's of...
Ask SSC