RedGate SQLSearch & SQL Treeo friendship
Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...
2012-05-11
1,186 reads
Blog Posts
SQL Rally Wrap Up
Another SQL Rally has wrapped up in Dallas, TX and it was great event. My favorite part about these larger...
2012-05-11
1,479 reads
SQL Saturday #119 – One week to go
One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...
2012-05-11
727 reads
SQLRally 2012–Thursday
Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...
2012-05-11
710 reads
Tech Days 2012 in Kosovo
Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...
2012-05-11
1,851 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,411 reads
#SQLRally Women in Technology Panel of WIN AND AWESOMENESS
Best. Luncheon. EVAR.
I just finished up moderating this year’s Women in Technology panel here at SQLRally, and it was fantastic. ...
2012-05-10
705 reads
“Query cost (relative to the batch)” <> Query cost relative to batch
OK, so that is quite a contradictory title, but unfortunately it is true. There is a common misconception that the query with...
2012-05-10
2,340 reads
Command line to configure windows firewall for SQL server access
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
3,822 reads
Denali — Day 10: Sequence object
Denali – Day 10: Sequence object
Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...
2012-05-10
1,272 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