Overview of Published Articles – 2015Q1
Here is an overview of the articles I published in the first quarter of 2015.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...
2015-04-22
536 reads
Blog Posts
Padding Fields for Fixed-Position Data Formats
Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...
2015-04-22
8 reads
SQL Sentry Pro Explorer is worth it...
UPDATE: 2015-04-28 15:49
- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...
2015-04-22
691 reads
SQL Sentry Pro Explorer is worth it…
UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...
2015-04-22
299 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking
For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...
2015-04-21
725 reads
Exam Prep 70-463: Installing Master Data Services
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-21 (first published: 2015-04-13)
5,490 reads
Follow the yellow brick what? My road to public speaking.
Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...
2015-04-21
1,985 reads
How to Configure E-mail in SQL Server Step by Step–TIP #96
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...
2015-04-21
621 reads
In Memory Optimized Table in SQL Server 2014
To increase performance of highly accessible tables, a new feature incorporated in Sql Server 2014 “In-Memory OLTP”.You can define a...
2015-04-21 (first published: 2015-04-11)
8,232 reads
Moving SQL Server data between filegroups – Part 1 – Database Structures
Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...
2015-04-21
8 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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...
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...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
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