Database Maintenance Plans: A Primer
Databases and newborns have a lot in common. They both require constant care. They both require constant monitoring. They also...
2014-10-20 (first published: 2014-10-14)
7,044 reads
SQL Server Checksum
Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...
2014-10-14
2,391 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-
Mirroring stateDescriptionSYNCHRONIZINGThe contents of the mirror database are...
2014-10-14
2,010 reads
T-SQL Tuesday #59: My Hero
This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).
Ada...
2014-10-14
1,197 reads
T-SQL Tuesday #59 – My Hero!
It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one...
2014-10-14
610 reads
Operation Souza
This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past...
2014-10-13
861 reads
Last Weeks Top “Reading” Links #104
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-13
1,059 reads
Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP LOG USERDB1 TO DISK =...
2014-10-13
20 reads
Notes From the October 9, 2014 Space Coast SQL Meeting
Not a bad drive over from Orlando. Only a little traffic, about 80 minutes. I was early enough to have...
2014-10-13
925 reads
Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
51 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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