Power BI Custom Visuals Class (Module 42 – Stars)
In this module you will learn how to use the Stars Power BI Custom Visual. The Stars visual is a...
2017-03-14
844 reads
Blog Posts
T-SQL Tuesday #88 – The daily (database-related) WTF
It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and...
2017-03-14
481 reads
T-SQL Tuesday #88 – WTF
It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan, who I...
2017-03-14
910 reads
T-SQL Tuesday #88: My Top WTF Moments
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
587 reads
When Is It Appropriate To Store JSON in SQL Server?
Every once in a while I hear of some technologist say that relational databases are dead; instead, a non-table based NoSQL storage format is the way of the future....
2017-03-14
13 reads
2016/2017 Whitepaper Updates
One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...
2017-03-13
521 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...
2017-03-13
6 reads
A Collection of SQL Server Help Scripts
[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...
2017-03-13
1,476 reads
Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell
In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The...
2017-03-13
1,136 reads
Cumulative Update #11 for SQL Server 2014 SP1
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...
2017-03-13
488 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