WordPress, Project NAMI, and Azure
I’ve been running WordPress for years now and find it to be a solid solution for what I want to...
2014-12-24 (first published: 2014-12-16)
6,385 reads
Blog Posts
Playing with the log – VLF order while growing the log
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...
2014-12-23 (first published: 2014-12-17)
5,838 reads
SQL – How to Find Missing Sequence in a table
Problem statement:-
A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code...
2014-12-23
1,579 reads
SSIS #118–Is it an OLEDB or an SMO Server Connection?
OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...
2014-12-23 (first published: 2014-12-17)
7,866 reads
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office,
not a creature was stirring not even old Maurice.
With merriment going on...
2014-12-23
534 reads
Blink – Year is gone
As the door begins to knock I start to wonder who it can be. As I begin to open it...
2014-12-22
504 reads
Formatting Durations in SSAS: Caveat
I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...
2014-12-22
708 reads
Last Weeks Top “Reading” Links #114
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-22
670 reads
Outlier Detection with SQL Server, part 3.2: GESD
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...
2014-12-22 (first published: 2014-12-17)
6,592 reads
ROW_NUMBER SQL Server
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)
8,850 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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...
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