Managing Analysis Services Deployment - Part 3
Part 3 of this series, Shahfaisal Muhammed brings a common method of deploying your SSAS projects to a new server: backup and restore. The rest of the series covers other methods.
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...
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers