Goodbye Microsoft, Hello New Adventure
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s...
2014-07-17
477 reads
Blog Posts
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME...
2014-07-17
1,872 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation. SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’ FROM SYS.SERVER_PRINCIPALS WHERE SID =...
2014-07-17
11 reads
Modeling the Agile Data Warehouse with Data Vault – Review
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,744 reads
SSC Editorial: Access Disdain
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
624 reads
SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I find myself fighting with SSIS because it provides less...
2014-07-17
44 reads
Building The SQLSaturday Orlando Marketing Plan-Part 23
Here’s the latest update on our registrations. We’re still ahead of all our previous events, that’s good, and we’re 2...
2014-07-16
573 reads
IT books that should be on your shelf
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,214 reads
Presentation to the Baltimore SQL Group on July 15, 2014
I did an online presentation about PCI and Credit Card Security for BSSUG last night and it went pretty well,...
2014-07-16
676 reads
Remembering Reed Jacobson
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of...
2014-07-16
505 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers