SQLServer Log Shipping Work File ! What is this all about ?
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,277 reads
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,277 reads
Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from
http://support.microsoft.com/kb/2812412
Similar to CU2 there...
2013-03-21
1,435 reads
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,442 reads
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,928 reads
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would...
2013-02-26
1,924 reads
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why...
2013-02-09
1,205 reads
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...
2013-02-06
801 reads
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new...
2013-01-17
1,042 reads
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...
2013-01-11
3,292 reads
Lets start New Year with a very simple yet useful topic.
I am a big fan of out of box reporting...
2013-01-08
1,254 reads
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers