Backing Up Your Old Systems
I am currently on a project to review some older servers (SQL 2000 and 2005) for SIMPLE recovery (and therefore...
2012-02-16
450 reads
Tools to Monitor Performance of SQL Server
To gather statistical information on how a server is performing requires, you need to use operating system tools to gather...
2012-02-16
3,225 reads
PASS Data Arch VC presents Steve Simon - On Beyond Zebra AdventureWorks OR Where Did I Go Wrong?
I meet Steve when he came down from New England area for SQL Saturday #28 IN Baton Rouge, LA. He...
2012-02-15
746 reads
Comparing Inline and Multi-Statement Table-Valued Functions
Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...
2012-02-15
80,926 reads
Excerpt from Upcoming Book by Grant Fritchey Called Learn “SQL Server in a Month of Lunches”
Later this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will...
2012-02-15
1,671 reads
SQL Server 2012 (“Denali”): T-SQL Enhancements
SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with...
2012-02-15
5,165 reads
Meme 15 - LinkedIn
The #Meme15 assignment from Jason Strate (Blog/@StrateSQL) for February is to describe how and why we use LinkedIn. I felt...
2012-02-15
408 reads
SQLRockstar's SQL Someday
http://vimeo.com/33411604
This is a talk given by Thomas LaRock (@SQLRockstar to you Twitter-folk) at an event last fall in NYC called...
2012-02-15
389 reads
Dynamic Add/Remove file in Mirroring/Logshipping
Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...
2012-02-15
494 reads
SQL Server – DBA productivity and less is more
A typical DBA day can include a mixture of Operational, Engineering and Architectural tasks. Whilst maintaining 100% database server availability...
2012-02-15
717 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers