Getting Started with SQL Azure Development
SQL Azure provides features similar to a relational database for your cloud apps. We’ll show you how to start developing for SQL Azure today.
A Collaborative Approach To Table Compression
A start at identifying and creating TSQL statements for tables that may benefit from compression.
Operating in Failure
Today we have an editorial from Sept 25, 2005 being republished as Steve is on vacation. This one talks about the need to expect failure in our systems and code for it.
31 Days of SSIS – Recursive SSIS Package (6/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In the first post...
Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters
I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?
The Importance of My Cloud Data
Steve Jones likes the cloud, but doesn't necessarily trust it. After a recent Hotmail outage, he outlines a potential issue that he sees with cloud computing.
Data Conversion in SQL Server
Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a value to a column. Just occasionally, though, you'll find that data gets truncated, queries run slowly, or comparisons just seem plain wrong. Robert Sheldon explains why you sometimes need to be very careful if you mix data types when manipulating values.
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
DevWeek & SQL Server DevCon 2011
The 14th annual DevWeek conference takes place from 14-18 March 2011, at the Barbican Centre in central London, and once again incorporates two dedicated tracks on SQL Server, alongside seven concurrent tracks aimed at software developers.
NoSQL Basics
Today Steve Jones talks about NOSQL and why it might be important for SQL Server DBAs to understand more about it and be able to talk about when it is appropriate to use.
Blogs
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
BCA KCP Sudirman Mansion Telpon/WA:08137887595
BCA KCP Sudirman Mansion Telpon/WA:08137887595.Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G...
BCA KCP Graha Paramita Telpon/WA:08137887595
BCA KCP Graha Paramita Telpon/WA:08137887595.Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blok D-2,...
BCA KCP Gandaria City Telpon/WA:08137887595
BCA KCP Gandaria City Telpon/WA:08137887595.Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar...
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