SQL Saturday #695 Guatemala
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
101 reads
Blog Posts
SQLSaturday Madison – “Data Security for the Cloud” and “Three Steps to Lasting Encryption”
In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...
2018-03-23
233 reads
T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026
Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...
2018-03-23 (first published: 2018-03-13)
2,446 reads
Data experiments with salary survey – I
As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how...
2018-03-22 (first published: 2018-03-12)
2,733 reads
Getting Started With R In SQL Server 2017
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,313 reads
Recruitment Agents are not bad people...despite what you might read
Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...
2018-03-22
366 reads
SQL Vulnerability Assessment for Azure SQL Database
Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....
2018-03-22
997 reads
Dates and Times in SQL Server: DATETIME2
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-21
341 reads
Extended Events File Initialization Failure
It should come as no surprise that I write a lot of articles about Extended Events (XE). This happens to...
2018-03-21 (first published: 2018-03-09)
5,832 reads
Moving a table using BCP and native format
You need to move a table from one instance to another with the following requirements:
The instances are on separate domains....
2018-03-21
368 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