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,933 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,682 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,197 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,182 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,070 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,358 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
760 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
950 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
862 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,114 reads
Blogs
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers