Columnstore Indexes – part 100 (“Identity”)
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be...
2017-03-25
797 reads
The Public Speaking Roadmap
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like....
2017-03-25
341 reads
Using Pester with dbatools Test-DbaLastBackup
In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the...
2017-04-11 (first published: 2017-03-25)
1,663 reads
TSQLTuesday.com – Quick WordPress Setup in Azure
When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting...
2017-03-24
1,134 reads
Querying SQL and Windows Version Info with T-SQL
Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself. There are...
2017-04-10 (first published: 2017-03-24)
31,904 reads
A Note on Configuring HP SSD’s
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage...
2017-03-24
433 reads
Answer to “Could not locate file ‘xxx_Log’ for database ‘xxx’ in sys.database_files”
This blog post is a form of resolution to the issue of not being able to shrink a transaction log...
2017-03-24
232 reads
Why did my SQL Server database just go offline?
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
384 reads
Configuring KDIFF With GitHub
Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and...
2017-04-12 (first published: 2017-03-23)
878 reads
U-SQL Defined
Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately...
2017-03-23
501 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers