Author of the Year at MSSQLTips.com
I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at...
2015-01-13
515 reads
Koen Verbeeck
The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
769 reads
Better late than never…
Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...
2015-01-08
626 reads
Overview of Published Articles – 2014Q4
Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...
2015-01-07
524 reads
Formatting Durations in SSAS: Caveat
I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...
2014-12-22
708 reads
Nominated for the 2014 Tribal Awards
Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...
2014-12-18
853 reads
PASS BI VC recording is available now
The recording of the webinar I did for the PASS BI virtual chapter is live!
(Quick reminder: it was the same...
2014-12-05
729 reads
Beware the defaults! (in windowing functions) – The Movie!
I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...
2014-11-27
1,068 reads
Nominated for Author of the Year
I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at...
2014-11-20
520 reads
PASS BI VC: How to (not) torment your fellow SSIS developer?
On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS...
2014-11-12
693 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers