Make BOL your friend
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,024 reads
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,024 reads
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,476 reads
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
687 reads
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...
2014-06-20 (first published: 2014-06-18)
2,333 reads
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,162 reads
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
838 reads
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...
2014-06-09
884 reads
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,592 reads
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,047 reads
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....
2014-06-02
1,923 reads
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Comments posted to this topic are about the item Do You Really Need HA?
Comments posted to this topic are about the item The New Database CheckDB
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers