TSQL Challenge 18 - Generate text formatted month calendars
Can you generate a calendar with T-SQL? Take this month's challenge.
2009-11-30
3,924 reads
Articles
Converting a File with Parent-Child Records in SSIS
Convert a file with multiple record types that have a parent child relationship.
2009-11-27
5,841 reads
Deploying Reports on Windows 7
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-11-27
2,033 reads
Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
2009-11-27
3,278 reads
How to simulate transparent data encryption (TDE) with SQL 2000 and 2005
Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.
2009-11-27
4,390 reads
Increase Your Value as a Professional in the Technical Industry
It has never been so important to enhance your employability as it is today. Job security can never be taken for granted. Employability, increasing your professional value, means far more than just collecting qualifications, as Dr Masha Petrova explains: It also involves communicating, writing, and participating in communities.
2009-11-27
2,850 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
831 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
1,164 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
1,085 reads
4 Ways to Increase Your Salary (Using UPDATE)
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
42,976 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
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
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