Business Intelligence Roles and Team Composition
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is...
2014-06-17
458 reads
SQL Server BI Blog
SSAS Performance Logger Now Available
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you...
2014-06-03
476 reads
What Does it Cost to Implement a Business Intelligence Project?
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This...
2014-05-17
983 reads
What’s Happening at the PASS Business Analytics Conference?
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
444 reads
Creating a Dynamic, Parameterized Measure in DAX
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value...
2014-04-20
874 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
733 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
364 reads
Showing a 100% Progress Gauge in Power View
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. ...
2013-08-01
791 reads
DAX: Returning the Nth Selected Value in a Slicer
A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that...
2013-07-13
741 reads
We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
2013-07-09
718 reads
Blogs
Heading to SQL Bits 2025
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
By John
In a recent video, I took a hands-on look at the Next Gen General...
Why India’s NEW Tax Regime is a GAME CHANGER for the Job Market
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
Forums
XML_COMPRESSION for existing tables
We are in the process of upgrading to SQL Server 2022 and would like...
How to Choose the Right Tool for MS SQL to PostgreSQL Migration
Comments posted to this topic are about the item How to Choose the Right...
Adding Defaults
Comments posted to this topic are about the item Adding Defaults
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