SQL Saturday #37 - Philadelphia
Come to this great one day training event in Philadelphia, PA. SQL Saturday is a great way to get free training on all aspects of SQL Server.
2010-02-24 (first published: 2010-02-04)
2,952 reads
Articles
Dynamically Map Column Data Based on Column Pattern Profiling
Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.
2010-02-23
3,340 reads
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.
2010-02-23
3,848 reads
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.
2010-02-23
2,831 reads
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...
2010-02-23
3,142 reads
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.
2010-02-23
2,484 reads
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...
2010-02-23
4,134 reads
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.
2010-02-22
10,797 reads
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...
2010-02-22
3,693 reads
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.
2010-02-22
4,532 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers