Splitting Strings Based on Patterns
Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.
2014-09-12 (first published: 2012-11-29)
33,521 reads
Articles
DBAs vs Developers: A Sad Tale of Unnecessary Conflict
For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA, and explains how to deal professionally with the inevitable friction between development and operation activities in IT.
2014-09-12
12,291 reads
SQL Server Hybrid High Availability and Disaster Recovery
This article summarizes the factors to consider and provide an overview of various options for HA and DR in cloud based SQL Server deployments.
2014-09-11
7,592 reads
Are you bad enough to join the DBA Team
If you've ever had a terrible day, send in your story and Grant and Steve will pick their favorite to be spiced up DBA-Team-style. The winner will also be given a ticket to SQL Cruise 2015. Find out how to enter.
2014-09-10
1,407 reads
Chris Date and the Relational Model
Chris Date is famous for his writings on relational theory. Chris took on the role of communicating and teaching Codd's relational theory, and reluctantly admits to a role in establishing SQL as the dominant relational language. Richard Morris interviews the well-known author and computer scientist.
2014-09-10
7,908 reads
Basics of Dimensional Modeling
Introduction of how to design a star schema dimensional model for new BI developers
2014-09-09
8,487 reads
SQL Server Live! Orlando, FL
SQL Server Live! is designed to finely tune the skills of DBAs, developers, Business Intelligence specialists (just to mention a few) with five days of workshops, deep dives and breakout sessions from November 17 - 21 2014.
2014-09-09
468 reads
Importance of Recovery Model in SQL Server
Have you ever wondered why the transaction log file grows bigger and bigger? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.
2014-09-09
7,601 reads
A Call for Questions
Our Question of the day is very popular, but we're looking for more complex questions
2014-09-08
650 reads
Silicon Valley Code Camp
Code Camp is a community event where developers learn from fellow developers. This year's event will take place on October 11-12 in the Los Altos Hills in California. Speakers include Steve Jones, Nik Molnar, Anthony van der Hoorn, Mike Wood, and more. Register while space is available.
2014-09-08
6,152 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Lindeteves Tlpn/wa:085373737551
Gedung Hayam Wuruk Indah, Jl. Hayam Wuruk No.100 Lt 1 Blok A-L 01,CKS 056,...
BCA KCP Cyber 2 Telpon/WA:08137887595
BCA KCP Cyber ??2 Telpon/WA:08137887595.Gedung Cyber ??2 Lantai Dasar, Jl. HR Rasuna Said 5...
BCA KCP Cyber 2 Telpon/WA:08137887595
BCA KCP Cyber 2 Telpon/WA:08137887595.Gedung Cyber 2 Ground Floor, Jl. H. R. Rasuna Said...
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