Database Development Tasks Survey
We'd like to better understand the kinds of database related development tasks that you perform, so that we can ensure our tools are helping you to be more productive.
Back to Vegas
The DevConnections conference in the spring of 2012 is in Las Vegas, and Steve Jones is glad to be going.
How to get monthly YTD data
This article presents an easy method to get YTD data grouped by months in T-SQL.
Physical Database Design Consideration
There are lots of things to think about when you design a physical database. What data types should I use? What column is appropriate for the primary key? Are there particular indexes that I should use to improve performance? How should I implement data integrity rules? This list goes on and on. In this article Greg Larsen will be exploring different physical database design elements.
Jiggly Code
There should be some method to your madness when fixing code. At least, that's what Linus Torvalds thinks and Steve Jones agrees.
Testing times
Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.
TSQL Challenge 74 - Find the expiring quantity of material
The challenge is to create a query for a report that show expiring material
Using the MERGE Statement in SSIS Via a Stored Procedure
Step-by-step instructions how to build a stored procedure that dynamically constructs and executes a merge statement within SSIS.
Tom LaRock's SQL Server Howlers
In this next article in our series where well-known SQL Server people write about their favorite SQL Server Howlers, we asked Tom Larock for his top five common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Taman Aries Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Taman Aries Blok E1 No. 2A & 2 B, Meruya Utara,...
BCA KCP KS Tubun Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jalan Letjen. S. Parman Kav. 28, L No.216-217, RT.12/RW.6, Tj. Duren Sel.,...
BCA KCP Rantai Mulia Kencana Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Pesanggrahan Jl. Puri Kencana No.28 29, RT.2/RW.7, Kembangan Sel., Kec. Kembangan,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers