Configure MOSS without GUI || Database name without additional GUID || PSCONFIG command to configure MOSS
Friends, do every time we need the GUI ? or we feel the need of Customized things some times in life....
2013-02-21
1,131 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 8: Sequence Clustering
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,029 reads
MDX #26 – SSN can only be referenced as a member property in MDX
I’ve blogged about the Properties() function before.
MDX #11 – How to get number of cars each customer owned using Properties() function?
MDX...
2013-02-28 (first published: 2013-02-21)
1,964 reads
Windows 2012 for the DBA Setting Your Server to High Performance
Hello Dear Reader! I’ve been doing a lot of work with Windows Server 2012 lately. The interface is wildly different...
2013-02-27 (first published: 2013-02-20)
3,540 reads
A Month of PowerShell – Day 20 (Databases: Table-Valued Functions)
Welcome to Day 20 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26 (first published: 2013-02-20)
2,762 reads
SQL Agent and the case of the missing job owner…
One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some...
2013-02-20
736 reads
SQL Saturday #177 – Silicon Valley
There is something about the Silicon Valley that attracts the innovative and creative individuals. The “misfits, rebels, troublemakers, and the...
2013-02-20
929 reads
T-SQL Tuesday #39 – Wrapup
Last week, I hosted the T-SQL Tuesday blogging party event, and the topic was on how do you use PowerShell...
2013-02-19
986 reads
Cumulative Update – 5 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 5th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-02-19
1,917 reads
Cumulative Update – 6 for SQL Server 2012 Is Now Available !
The 6thcumulative update release for SQL Server 2012 is now available. Cumulative Update 6 contains all the hotfixes released since...
2013-02-19
842 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers