SQL Server – Row Level security in SQL Server 2016 – Part 1
Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...
2016-05-03
472 reads
Blog Posts
Weekly Round-up 30 April 2016
It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and...
2016-05-03
368 reads
Where Is My Primary Replica Again?
We have many clients with multi-node Availability Groups - that is, AGs with more than two replicas. One of the problems...
2016-05-03 (first published: 2016-04-22)
4,457 reads
Goodness-of-Fit Testing with SQL Server Part 7.3: The Anderson-Darling Test
By Steve Bolton
…………As mentioned in previous installments of this series of amateur self-tutorials, goodness-of-fit tests can be differentiated in many...
2016-05-02
1,375 reads
How to Convince the Boss to Send You to PASS Summit
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
973 reads
Monday Morning SQL Break – May 2, 2016
Gotta love Mondays. At least the weather here in Minnesota is clearing up, the last two weeks have been cold...
2016-05-02
456 reads
PowerSehll : How to suppress the table heading and remove the blank space from a text file
There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...
2016-05-02
7,818 reads
Remove files from a filegroup
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,643 reads
Setting up powershell remote sessions
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can...
2016-05-02 (first published: 2016-04-22)
1,896 reads
SQL 2016 - The Time Has Come!
Microsoft dropped it on us this morning:
Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg
I read the article and was...
2016-05-02
920 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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