Monday Coffee 2017-03-13
Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for...
2017-03-13
262 reads
Blog Posts
Not An Administrator For Analysis Services Tabular
A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created...
2017-03-13 (first published: 2017-02-28)
1,998 reads
SQL Clone and a Little Competition
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,755 reads
T-SQL Programming for Developers Course
Are you a software developer?
Did you ever get to develop a software that works with a Microsoft SQL Server database?
...
2017-03-13
801 reads
Using tSQLt to Find Min/Max Times
I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since...
2017-03-13
1,145 reads
Using Virtual Desktops for Presentations
Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...
2017-03-13
493 reads
TSQL2sday – Daily database WTF
This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...
2017-03-12
444 reads
Next Stop, SQL Saturday Richmond
I can’t believe it’s almost time for SQL Saturday #610. I’ll be there presenting What is Power BI? If you...
2017-03-11
330 reads
Thinking about Chapters (aka Groups)
I think it was 2003 or 2004 when someone from PASS came to Orlando and helped start what became OPASS....
2017-03-11
563 reads
A rare Reporting services issue
This post is about a reporting services configuration issue that you will face after changing the database server name. I’ve blogged about Changing SQL Server name and warned on...
2017-03-10
7 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