Aggregate Functions
Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...
2016-12-11
235 reads
Blog Posts
My Interview at SQL Server Geeks 2016
One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...
2016-12-11
394 reads
Linux – How to generate and configure SSH Key authentication to connect to a remote system
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
387 reads
Friday Reading 2016-12-09
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...
2016-12-09
362 reads
Hide and Group Columns in SSRS Using a Parameter
Ever had users come to you and request another version of a report just to add another field and group...
2016-12-09
607 reads
In Memory OLTP – 2
Good day everyone , In last post
In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...
2016-12-09
501 reads
Interviewed on Channel 9
Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player
Filed under: Blog Tagged: DevOps,...
2016-12-09
713 reads
NOLOCK
NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...
2016-12-09
2,325 reads
Validating a Set of Database Scripts using DLM Automation
The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or...
2016-12-09 (first published: 2016-11-28)
1,888 reads
Why won’t my SP work THIS time?
Why won't my SP work? I did this exact thing. You're never too old to do something like this.
The post...
2016-12-09
561 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