Resources from the PASS community this coming month
Even though it is December, I noticed a lot going on for FREE in the PASS Microsoft Data Technology community....
2017-11-30
608 reads
The Smiling DBA
IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers....
2017-10-25
8 reads
IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as...
2017-10-25
387 reads
SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date...
2017-09-29
78 reads
SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server...
2017-09-28
881 reads
Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates before you vote. Both tweeter events will be on...
2017-09-13
8 reads
Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates...
2017-09-12
509 reads
Analysis Services Series on SQLShack
Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with...
2017-08-17
28 reads
Analysis Services Series on SQLShack
Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document...
2017-08-16
744 reads
SQLSaturday Baton Rouge #628 2017
Come join around 500+ attendees and speakers learning and networking at the LSU College of Business – Business Education Complex on Nicholson Drive Extension in Baton Rouge on Saturday...
2017-07-21
3 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
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
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