The Bleeding Edge Versus N Minus One
Risk-averse managers are reticent to upgrade to the latest and greatest. Why is this the case and how can the savvy DBA make the case for and get ready for a newer version of SQL Server?
2016-06-28
2,231 reads
planning
Planning Ahead - Single Node Clusters
People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.
2009-06-17
6,162 reads
Database Server Upgrades – The Plan, The Template, and The Task List
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
2009-05-08
11,275 reads
RE: Middle Join
There is no such thing as a middle join. The question you saw was a trick question where the word "middle" becomes an alias for one of the tables.
2004-10-21
RE: Question of the Day for 20 Oct 2004
Although I got the right answer, it is not true to say that the results exactly match the results of sp_whosp_who resolves the database name (dbname) correctly whereas the query always seems to return 'master' as the dbname.To see what sp_who is doing, try running 'sp_helptext sp_who'
2004-10-20
RE: My own aggregate function
Here is your first question and my reply http://qa.sqlservercentral.com/forum/link.asp?TOPIC_ID=18953 Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-09
RE: User-defined fields
Recent post of same topic: http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=13248&FORUM_ID=49&CAT_ID=1&Topic_Title=Handling+%22optional+fields%22&Forum_Title=Strategies
2003-06-17
1 reads
RE: Source Control for UDF's???
I use VS.NET for all my database objects, not only SP's. If you select all your tables, views, ect in your database, right-click and choose "Generate Script..", you can make scripts for all your objects. Just choose a map that is part of your database project, and VS.NET takes care of the source control part […]
2003-06-16
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers