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,173 reads
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,173 reads
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
645 reads
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
580 reads
Next Meeting
Thu, Mar 24 2016 12:00 Central Daylight Time
Dustin Ryan presents What's New in Power BI
RSVP:https://attendee.gotowebinar.com/register/8425155555275941377
WHAT'S NEW IN POWERBI...
2016-03-16
551 reads
I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is...
2016-01-18
477 reads
Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...
2015-12-03 (first published: 2015-11-26)
3,316 reads
Please join Idera tomorrow for a #SQLChat on Twitter. The December #SQLChat will take place Tuesday, December 9 at 11...
2015-12-02
508 reads
I started using a product called SQL Diagnostic Manager from Idera about 10 years ago at a Home Health company....
2015-11-05
519 reads
Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server...
2015-10-19
521 reads
On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on...
2015-09-17
423 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers