SQLBits 2017 In April
I’m getting excited, with the announcement that SQL Bits 2017 is scheduled. The conference goes back to Telford, which I...
2016-12-12
529 reads
Blog Posts
The Eleven Days of Festivus
It’s that time of the year again – the Festivus season is upon us! In the next few weeks, families all...
2016-12-12
300 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t...
2016-12-12
343 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
82 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
16 reads
Aggregate Functions
Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...
2016-12-11
235 reads
My Interview at SQL Server Geeks 2016
One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...
2016-12-11
393 reads
Linux – How to generate and configure SSH Key authentication to connect to a remote system
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
387 reads
Friday Reading 2016-12-09
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...
2016-12-09
362 reads
Hide and Group Columns in SSRS Using a Parameter
Ever had users come to you and request another version of a report just to add another field and group...
2016-12-09
605 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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