The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post...
2017-08-23
1,125 reads
Koen Verbeeck
Fix for Blurry SSMS in Windows 10
I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a...
2017-08-14
7,578 reads
Two Small Tips for Working with Azure
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up...
2017-08-10
500 reads
SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local...
2017-08-08
3,508 reads
Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
283 reads
The times they are ae-changing
I have been quite on this blog for a couple of weeks now, and there are a couple of reasons...
2017-08-03
369 reads
Microsoft Professional Program in Data Science – Continued
A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...
2017-06-27 (first published: 2017-06-19)
2,858 reads
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it...
2017-06-20 (first published: 2017-06-13)
10,586 reads
Microsoft Professional Program in Data Science – The Road So Far
I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open...
2017-05-26
1,356 reads
Power BI Announcements Summary
It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap...
2017-05-05
1,375 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