SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,502 reads
The DBA Who Came In From The Cold
Index Fragmentation
So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...
2014-03-13
2,455 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
581 reads
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,003 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
531 reads
Happy New Year!
Happy New Year!
Hope you all had a good Xmas, ate too much, drank too much and are still telling yourselves...
2014-01-02
320 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
432 reads
My favourite online references
There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...
2013-11-19
410 reads
My 5 pieces of advice for new DBAs
As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...
2013-11-07
786 reads
Blogs
Daily Coping 30 Nov 2022
By Steve Jones
Today’s coping tip is to learn a new skill from a friend or share...
Encrypting Your SQL Data Should be Your Default Option
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...
Power BI Embedded: Using Row-Level Security for Multilingual Reports
By DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
Forums
Designing Database from a piece of paper
Greetings experts, Hopefully, this is the forum for my question. I am trying to...
Error: Column names in each view or function must be unique
I am getting the error: Column names in each view or function must be...
Ask SSC