SQLSaturday Sites Will be Offline For Part of April 27, 2010
We’re scheduled to begin moving web sites and data to PASS servers at 12:00 pm Eastern on April 27, 2010....
2010-04-26
489 reads
Blog Posts
SQLSaturday Success! NYC #39, has left the building.....
Well, it’s Monday morning and back to the DBA salt mines!
Now that SQLSaturday #39 is all but a joyful...
2010-04-26
571 reads
SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
552 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
3,087 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
1,549 reads
Upgrading your Beta/CTP Software
This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that...
2010-04-26
1,159 reads
A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,699 reads
Need Data from a Mac: TransMac for Reading HFS Volumes a Lifesaver
Recently I was handed over a HFS volume to read from my colleague who uses his Macbook exclusively. We had...
2010-04-25
1,040 reads
Speaking at Auckland, New Zealand SQL Users Group
On Tuesday Morning at 2:00 am EST time I will be speaking at the Auckland SQLUsers Group. This will be...
2010-04-25
543 reads
A DMV a Day – Day 24
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
961 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers