2014 PASS Summit 2014 Board Q&A Notes
As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session...
2014-11-17
693 reads
Kendal Van Dyke
PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!
Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and...
2014-09-23
521 reads
Presenting At OPASS August 2014 Meeting On 8/28
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User...
2014-08-27
1,183 reads
Thoughts On The 2014 PASS Summit Selections
The session lineup for the 2014 PASS Summit was announced today and I'm honored to be selected as a presenter....
2014-06-25
1,326 reads
I'm A Candidate For The 2014 PASS Nomination Committee
The 2014 PASS election cycle begins today when voting opens for the Nomination Committee (NomCom) and I'm one of eleven...
2014-06-03
1,115 reads
Using sys.objects When Scripting Permissions? You're Missing Something!
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,105 reads
How To Get The TableDiff Utility
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables...
2013-12-05
2,559 reads
Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,198 reads
SQL Power Doc Update - Version 1.0.2.1
I'm at the 2013 PASS Summit in Charlotte, NC, this week, and presented a session about documenting your databases using...
2013-10-17
1,267 reads
What Does The PASS Community Mean To You?
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the...
2013-10-11
706 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