MDX Utility Belt of Calculations Part 3
This is part three in a series of blog posts that will help you build an arsenal of MDX calculations...
2009-12-09
1,503 reads
Articles
Query Active Directory Data from SQL Server using T-SQL
Learn how to use SQL Server Transact SQL with OPENROWSET and OPENQUERY commands to access and retrieve data from Active Directory.
2009-12-09
5,402 reads
Introduction to Common Table Expressions
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,223 reads
Best Practice for renaming a SQL Server Database
One of the Junior SQL Server Database Administrator in my company approached me yesterday with a dilemma. He was assigned a task to rename few of the databases in Beta and Production environments; the reason being the database name was based on some other project that is no longer relevant to the data which is presently stored within the database. At first I started to tell him, but figured it would be smarter to document the same and share the information.
2009-12-08
6,195 reads
Electronic Health Records – What’s the Big Deal? (Part 3)
In the previous post in this series, I discussed the obstacles to implementing electronic health data systems. Because of these...
2009-12-08
1,264 reads
Fun With SQL Azure
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-08
1,844 reads
Life Logging
Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2009-12-08
1,714 reads
Life Logging
Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2009-12-08
3,356 reads
Life Logging
Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2009-12-08
702 reads
Enterprise SQL Job Activity Reporting
A SSIS/SSRS solution that provides SQL job activity for all your SQL Servers.
2009-12-07
7,241 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
buka blokir Btn Salah pin 3 kali
Buat buka blokir akun Bank BTN kayak BTN Mobile, kamu bisa hubungi WhatsApp Call...
Cara membuka blokir aplikasi BTN mobile banking
Untuk membuka blokir akun Bank BTN seperti bale by BTN atau BTN Mobile, hubungi...
Cara Buka Blokir Qlola By BRI
Cara membuka blokir BRI Qlola/ by BRI dapat dilakukan dengan menghubungi Call Center (0818)-3983-99,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers