When Did SQL Server Restart?
I saw Joe Webb’s post, and then Gethryn Ellis’ post as well on when SQL Server last restarted. It’s something...
2010-05-03
450 reads
Blog Posts
SQL Server 2008(R2) and Win Server 2008 R2 Core Edition
The WinServer 2008 Core Edition was the server that you cannot install the SQL Server 2008. The Win Server 2008...
2010-05-02
1,513 reads
SQLSaturday #39 NYC Presentations available online....
SQLSaturday #39 NYC Presentations available online....
If you were at SQLSaturday in NYC and want to see it again, or, you...
2010-05-02
956 reads
With Great Advice Comes Great Responsibility
I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...
2010-05-02
571 reads
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,160 reads
SSIS : Data Flow paths
I had a very interesting bug that had me running around for over a week. Turns out the bug was...
2010-05-01
875 reads
TempDB Internals
TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...
2010-05-01
1,858 reads
A DMV A Day – Day 30
The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:
Returns information about all the data pages that...
2010-04-30
3,263 reads
Marathon Schedule
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...
2010-04-30
1,481 reads
PASS Update #30 (Surveys)
Recently we released the results of the annual survey to determine interests for the 2010 Summit. That’s a step in...
2010-04-30
2,050 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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