Database In Recovery
What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...
2012-06-04
1,270 reads
Blog Posts
SQL Server Professionals: NYC Summer Spectacular! Training & Events
This is a very exciting summer to be in New York City! We’re not just talking Central Park, the Theatre...
2012-06-04
1,610 reads
Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?
Is it just me, or does there seem to be a lot of discussion these days about testing backups and...
2012-06-04
1,516 reads
Tips to avoid deadlocks?
A database server should be able to service requests from a large number of concurrent users. When a database server...
2012-06-04
3,371 reads
Jacksonville IT Pro Camp
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,233 reads
SQL Server Service Broker Explained
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
195 reads
Investment for DBA Career
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....
2012-06-02
1,059 reads
Max Server Memory
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,165 reads
Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
890 reads
I’m Going on Tour
I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I...
2012-06-01 (first published: 2012-05-30)
2,270 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers