PASS Summit 2016-Thursday Part II
The second half of the day was spent talking with various speakers and attendees. I got into a great conversation...
2016-10-28
808 reads
The Smiling DBA
PASS Summit 2016-Thursday Part 1
Today’s keynote was by David Dewitt. He did an excellent job explaining the architecture behind various Cloud Data Warehouse offerings....
2016-10-27
402 reads
PASS Summit 2016-Wednesday
As all Summits, the first Regular Session day in Seattle started with the Keynote. Well, really it starts with a...
2016-10-27
490 reads
PASS Summit 2016–Tuesday
For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera...
2016-10-25
475 reads
VOTE!!! PASS Board of Director Elections
It is voting season again, and there is a great group of individuals running for the Board of Directors of...
2016-10-06
360 reads
Live! 360–Speaking at SQL Server Live Orlando 2016
If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different...
2016-09-10
608 reads
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you...
2016-07-26 (first published: 2016-07-21)
5,327 reads
PASS Summit 2016 – Connect, Share, Learn
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th....
2016-06-24
543 reads
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,147 reads
SQLSaturday Atlanta #521 May 19th & 20th 2016
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
637 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Alamat Kantor BCA KCU City Tower Telp:08218200233
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
Alamat Kantor BCA KCU Matraman Telp:08218200233
Wa:628218200233 Alamat. Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
Alamat Kantor BCA KCU Menara Bca Telp:08218200233
Wa:628218200233 Alamat. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5, Menteng,...
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers