What SQL version is my SSIS package?
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how...
2015-04-27
1,101 reads
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how...
2015-04-27
1,101 reads
This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t)...
2015-04-23 (first published: 2015-04-14)
5,322 reads
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...
2015-04-22
497 reads
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...
2015-04-20
1,498 reads
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...
2015-04-16
823 reads
I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master...
2015-04-08
813 reads
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade....
2015-04-06
692 reads
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...
2015-04-03 (first published: 2015-03-30)
8,828 reads
It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as...
2015-04-01
483 reads
I have a customer who is having a problem with a load. He is getting a fair number of bad...
2015-03-25
1,098 reads
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
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...
Hi, we lost our sever sql2000 To restore database to a new one we...
Hi, since we lost our sql server 2000 server we are trying to restore...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers