SQL Server Pro Article: Custom Programming to Enhance SSRS Reports
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...
2013-07-02
909 reads
SQL Server BI Blog
Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
585 reads
Time to Complete the 2013 BI Survey
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take...
2013-06-10
496 reads
Taking the Tabular Journey
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services....
2013-06-02
782 reads
Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
791 reads
Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past,...
2013-03-08
1,083 reads
SQL Server Community World Tour with GeoFlow
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This...
2013-03-06
701 reads
Speaking at the Business Analytics Conference, April 1-12 in Chicago
The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please...
2013-02-06
681 reads
Database Lifecycle Management for Azure SQL Database
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,916 reads
Reporting Services 2012 BI Training
Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert...
2012-12-10
1,532 reads
Blogs
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Forums
Shades and Reflecting on SQLBits and the Bright Future of Data
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers