Warming up Analysis Services with Preallocate
With Windows Server 2003 many people found that Analysis Services (SSAS) was slow to get going sometimes. So a preallocate...
2009-09-03
1,747 reads
Blog Posts
24 Hours of PASS was an Adventure
On July 21, just a few short weeks ago, I got an e-mail from Rick Heiges, who is on the...
2009-09-02
656 reads
Article of the Week – SQL Server 2008 T-SQL Enhancements
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
746 reads
Building a Better Blog
I had a great session for the 24 Hours of PASS on Building a Better Blog. Not sure how well...
2009-09-02
641 reads
Data Type Synonyms
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
631 reads
Finally Migrating from SQL 2000
I suspect I’m not alone in that I’ve had SQL 2000 running for a long time with no problems and...
2009-09-02
421 reads
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-02
1,447 reads
How To Get Table Row Counts Quickly And Painlessley
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
446 reads
Nice Discounts On Microsoft Certification Exams From Prometric
Prometric is offering 15% or 20%, or 25% off on selected Microsoft certification exams. The lower level Technology Specialist (TS)...
2009-09-02
601 reads
SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
634 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers