A second week at SQLskills – performance tuning
G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...
2011-08-14
1,165 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
Select from a table with no rows returned.
G’day,
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table...
2011-07-04
5,001 reads
Meme Monday for June – there are no dumb questions
G’day,
Here’s my input into this months Meme Monday – there are no dumb questions.
It seems (at least to me), that – occasionally...
2011-06-06
1,691 reads
Free SQL Exam cram sessions from Microsoft.
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,927 reads
A curious case of a missing configuration group.
G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...
2011-05-12
1,488 reads
Catalog view or compatibility view?
G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...
2011-05-08
3,003 reads
Certifications – and a survey.
G’day,
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them...
2011-05-05
722 reads
How do you create or update stored procedures.
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,936 reads
Checkpoints and the Lazy writer
Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...
2011-05-02
20,301 reads
Meme Monday – “I got 99 problems but a disk ain’t one”
G’day,
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been...
2011-05-02
731 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers