Speaking at MagicPASS on February 22, 2012
Next Wednesday I’ll be returning to MagicPASS to do a presentation on SQL security for developers. It’s an interesting topic,...
2012-02-17
682 reads
Blog Posts
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,416 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
45 reads
SQL Server – read only database status
This post describes how to return the database read-only status via T-SQL .
The system view – sys.databases returns a column called...
2012-02-17
1,119 reads
SQL Server 2012 (“Denali”): Microsoft StreamInsight
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event...
2012-02-17
3,146 reads
Your Road to Becoming a DBA: Getting Organised
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-17 (first published: 2012-02-13)
2,325 reads
Automate CPU-Z Capture to Check for Throttled Processors
Severalprofessionalshaveposted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to...
2012-02-16
1,138 reads
Automate CPU-Z Capture to Check for Throttled Processors
Several professionals have posted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to check your servers every couple of...
2012-02-16
45 reads
Backing Up Your Old Systems
I am currently on a project to review some older servers (SQL 2000 and 2005) for SIMPLE recovery (and therefore...
2012-02-16
408 reads
Blogging: Controlling SPAM in Orchard CMS with OpenCaptcha
When I started blogging last year, my first major decision was either to host my own site somewhere using a...
2012-02-16
1,808 reads
Blogs
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...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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