More Bloopers for Memorial Day
It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in...
2011-05-30
1,657 reads
Blog Posts
Optimizer Timeouts with XQuery
I was looking at performance of a database and I noticed a few of the plans were very large and...
2011-05-30
2,119 reads
SQL Query Run Time Estimation
A followup to a post about subqueries with an estimation for how long it would take for the query to...
2011-05-30
3,489 reads
Can Scrum work for the DBA?
Agile! Scrum! Development methodologies! Sprint!
If you have a manager who reads any web page about being a manager, then you...
2011-05-29
8,416 reads
SqlHerts–26th May 2011
Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay. Its a true pleasure to...
2011-05-29
1,335 reads
Accidentally Dropped the Distribution Database
Have you made the mistake of dropping your distribution database like this?
If so, remember not to do this ever again. ...
2011-05-28
2,027 reads
ACID Rules in Sql Server
ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity states the principle of All...
2011-05-28
4,192 reads
DML, DDL, DCL, TCL in SQL Server
Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...
2011-05-28
11,726 reads
Restoring a database from higher version to lower version SQL server
AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...
2011-05-28
3,035 reads
Using Views for Faster SQL Query Development
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...
2011-05-28
845 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers