An Attempt to Make SSIS Package Deployment More Reasonable
Full disclosure: There might be a better way to do this. I am not aware of it.
Problems:
Maintaining multiple DB environments...
2011-11-03
1,468 reads
Blog Posts
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
4 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,265 reads
DDL Auditing presentation – feedback
Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than...
2011-11-03
775 reads
Dimensional Modeling Financial Data in SSAS pt2
Unary Operator and Aggregating over time
In my last post I discussed how to arrange all of the GLs into a...
2011-11-03
3,269 reads
Find Recently Run Queries
If you have ever closed a query window by accident only to wish you could get back your work an...
2011-11-03
3,993 reads
Recording SQL Server Configuration Settings.
(I’m ‘standing in for Brad, who is busy ..er.. somewhere, and I found this unpublished piece by Brad and I....
2011-11-03
1,418 reads
SQL Server 2012: Business Intelligence Edition
Well this was quite the little surprise this morning. Microsoft announced a new edition to the SQL Server lineup for...
2011-11-03
2,718 reads
Correction of my unfair and incorrect words against SQLWorkshops.com
On October 18, 2011 I have made unfair and incorrect words on Twitter, Facebook, LinkedIn,
and Xing against the owners of...
2011-11-02
770 reads
Latest post from Bill Gates featuring Hans Rosling’s animated bubble graphs
I just caught a tweet from Bill Gates with yet another fascinating presentation from Hans Rosling on the Gates Notes...
2011-11-02
783 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