70-457 Reviewer #15 Implement Database Mirroring
This reviewer is part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of the...
2013-11-10
536 reads
Coffee and SQL
70-457 Reviewer #14 Database and Application Roles
This lesson is part two of lesson Reviewer #13 Managing SQL Server Logins. There is so much to cover about...
2013-11-10
419 reads
70-457 Reviewer #13 Managing SQL Server Logins
This lesson covers managing security principals at the instance level. Security principals at this level allows access to the instance...
2013-11-10
619 reads
Strategizing your Index Maintenance in SQL Server
Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or...
2013-09-28
1,249 reads
Poor Microsoft Doesn’t Understand What Tablets Are For
That’s the title of an article i came across this morning in Slate.com. I am not a big fan of...
2013-09-24
643 reads
Cumulative update package 6 for SQL Server 2012 SP1
Microsoft has release the CU update package 6 for SQL Server 2012 SP1. To apply this package in your environment,...
2013-09-23
1,315 reads
Brad Shultz's blog on reviewing your database
Reblogged from SQL Studies: This is possibly the best blog I have every read on the subject of reviewing a...
2013-09-18
571 reads
CIO Report; 14 things you need to know about Data Storage Management
Reblogged from Imtech ICT UK Blog: Original Article: CIO recently published a detailed article on the 14 things you need...
2013-09-18
645 reads
Debugging database mail issues in your SQL Server with T-SQL
Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out...
2013-09-17
1,089 reads
Certifications: What are they good for?
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
614 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers