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
Blog Posts
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
2012-02-08
1,157 reads
My upcoming speaking engagements
In the last weeks it was very silent on my weblog, but life is pretty fast in 2012.
Currently I'm preparing...
2012-02-08
570 reads
Not enough storage is available to complete this operation
This message appears in the TDP SQL dsmsched file. It’s usually associated with low levels of contiguous memory
BackupVirtualDeviceSet::SetBufferParms: Request large...
2012-02-08
3,435 reads
RYO Maintenance Plan – Database Backups, Part 3
4 out of 5 DBAs agree
I’ve covered creating my backup directories and the actual backup of the database(s). The last...
2012-02-08 (first published: 2012-02-06)
2,305 reads
Using Reporting Services as your Software Frontend
Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to reports of...
2012-02-08
673 reads
What is Microsoft Connect?
Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...
2012-02-08
750 reads
Whitepaper – Extending Reporting Services with Custom Code
Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing...
2012-02-08
1,643 reads
Blogs
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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