SQLServer 2008 R2 SP3 released, Now its testing and deployment time!
As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and...
2014-09-29
1,438 reads
SQLSailor.com
Building a Virtual Machine within Azure (IaSS) – Improvements !
Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows...
2014-08-18 (first published: 2014-08-12)
7,408 reads
Microsoft Azure Portal Preview looks promising !
This is one of those posts which is pending for a very long time. I was pretty excited when Azure...
2014-06-26
945 reads
Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,949 reads
Data Collector in SQLServer 2014 – What’s New !
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,787 reads
SQL Server 2014 Install – Step by Step
Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh...
2014-04-01
19,245 reads
Folks,Know your Outbound Data Transfer Costs – Windows Azure
The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.
Yes, when I...
2014-03-25 (first published: 2014-03-19)
2,682 reads
Rollback DBCC CHECKDB REPAIR !
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,567 reads
One error which you don’t want to see while doing upgrades – Missing MSI !
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,206 reads
Setting up the Min and Max Memory options on the fly – Word of caution !
Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...
2014-01-02
829 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