February #Meme15 Assignment
It’s been a couple months now since a number of us got together to share how we use social networks...
2012-02-09
575 reads
Blog Posts
SQL Server 2012 (“Denali”): Data Quality Services
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...
2012-02-09 (first published: 2012-02-06)
2,705 reads
SQL Server Product Life Cycle
Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range.
The...
2012-02-09
1,135 reads
SSAS: Currency Conversion in MDX Script
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
1,004 reads
Stages of the Game?
Saw this post by Seth Godin on Stages of the Game. Interesting, I identified with it – I’m competitive, and competing...
2012-02-09
827 reads
[Shameless Plug] Can We Have Your Vote?
[Shameless Plug] Can We Have Your Vote?
SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...
2012-02-08
1,059 reads
A Script A Day - Day 8 - Non Clustered Index Information
Today's script comes to you from London where I am at my head office for my appraisal! Lets hope it...
2012-02-08
448 reads
AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-08
1,081 reads
An Unclassy Error
I saw this on a TV while walking through a store. More than a but amusing, but not too helpful...
2012-02-08
625 reads
Goals 2012
As I have wanted to do each year, here is my goals post for 2012. Last year I set out to do this very same thing but was very...
2012-02-08
1 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