Multiple Mirrors
Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.
Professional Microsoft SQL Server 2008 Reporting Services - Sample Chapter
Learn about SQL Server 2008 Reporting Services with this new title from Wiley. We have a sample chapter you can read to see if you like this book.
Development Lifecycle Deployment SSAS, SSRS, SSIS
Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these...
SQL Server Lazy Writer Issue: Warning, No Free Buffers Found
This tip is intended to help someone who is or will be facing a no free buffer found issue with the SQL Server LazyWriter. Recently, we experienced some unknown issues with our SQL Server and after inspecting the error log file we noticed the following errors: "SQL Server has encountered 50 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file..." and "LazyWriter: warning, no free buffers found." These error messages were followed by a SQL Server memory dump file like SQLDump0030.mdmp in the file system.
The T-SQL Hammer
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
Cleaning Up Garbage from Data
Cleaning up garbage from data can be a big problem for a developer.Check out a simple solution from Shubhajyoti Ghosh to cleaning up garbage from data.
FizzBuzz
Can most programmers not program? A new test, the FizzBuzz test, is being used to weed out candidates. Steve Jones comments on the types of FizzBuzz questions he's used in T-SQL.
Oracle: Overhaul or Overkill?
Vendor-specific hardware might make Oracle less painful to use in the future, so Chris Massey considers whether Microsoft should consider providing a more tailored and complete product with SQL Server. The verdict? "Not necessary".
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
Tips for Simplifying Crosstab Query Statements
Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU RAWAMANGUN Hub.0821•3111•185
BCA KCU RAWAMANGUN Hub.0821•3111•185 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
BCA KCP Citra 2 Ext TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02, RT.2/RW.8,...
BCA KCP Ebony - PIK 2 TLP/WA 08216977749
Pantai Kita, Soho Blok B.030, Unit SEB-030, Type Ebony 2 Jl. Pantai Indah Kapuk...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers