SQL 2016-Always Encrypted
As you know this has been introduced in sql server 2016, I am not going in details on it but...
2016-05-07
456 reads
Blog Posts
A strange OS bug on a SQL Server migration
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS packages on quite a big database of 450 GB,...
2016-05-06
3 reads
A strange OS bug on a SQL Server migration
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS...
2016-05-06
108 reads
A strange OS bug on a SQL Server migration
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS packages on quite a big database of 450 GB,...
2016-05-06
5 reads
ALTERNATIVE TO DISABLING A SQL JOB STEP (FOR SSIS PACKAGES)
For relational data-warehouses where you have the data load scheduled during off hours, timing of different steps in a sql...
2016-05-06
1,285 reads
ETL Data Lineage
Before I began my technical career over a decade and a half ago, I spent several years working in law...
2016-05-06
1,268 reads
Go and See David’s Session at SQL Bits on Saturday
In yesterday’s blog about the latest version of David’s book on SQL Azure I mentioned David was delivering his SQL...
2016-05-06
397 reads
PASS – A Business Case for Attendance
[read this post on Mr. Fox SQL blog]
For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say...
2016-05-06 (first published: 2016-04-25)
2,456 reads
SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security
Hello Dear Reader! I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events! Today my friend Dan Taylor (@DbaBulldog | Blog) and I are presenting our Pre-con...
2016-05-06
2 reads
SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security
Hello Dear Reader! I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events! Today my friend Dan Taylor...
2016-05-06
618 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers