 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Clownpocalypse and DR Today we have a guest editorial from Grant Fritchey as Steve is out of town. You plan and plan in preparation for the zombiepocalypse. You lay in weapons. You get food and water supplies built up. You take training in survival skills, martial arts, sword & firearms. You build a fence on the property and put in an alarm system along with your generator and a well. You are ready for the zombies to arrive. Heck, you’re kind of bored waiting for the zombies to arrive. What do you get? Clowns. Clowns? Clowns. Here’s the good news, all that preparation, funny enough, still applies to clowns. You’re still ready for a siege, but instead of shambling, rotting corpses, it’s a horde of clowns, all coming out of a single car. The training, the supplies, the weapons, they’re all still going to be useful. What happened to the Data Platform you ask? Here’s the thing, you don’t know what your disaster will actually be. Yeah, you might have severe database corruption caused by extra-solar radiation (same stuff you thought would cause the zombies) affecting your disks. All the backups and practice restores in preparation for that corruption will serve you well when it happens. What if it doesn’t. What if someone just turns off the SAN? Did all that preparation go to waste? Not at all. You’re still prepared. Whether it’s a flood from a hurricane, or a flood from bad maintenance in the bathroom of the floor above your server room, the preparations you’ve made are still useful. Yes, we’re all very disappointed that it’s a clownpocalypse instead of a zombiepocalypse. The good news is, regardless of the source of the trouble, the preparations made for it are still going to be useful. Same thing goes for all the work you do in setting up a proper disaster recovery processing for the data you manage. No clowns were harmed during the composing of this bit of whimsy. The same can’t be said of zombies. Grant Fritchey from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | Track schema changes for free DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool. |
|  | | Free whitepaper: Solving the database deployment problem with Database Lifecycle Management Learn how to use your source control, CI, and release management tools to make your database development process efficient, safe, and Agile. Start today with this free whitepaper. |
|  | | How to fix SQL Server disk I/O bottlenecks (without a hammer) In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now. |
|
|
|
| | |  | Alan Hyneman from SQLServerCentral.com EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time. More » |
 | Additional Articles from SQLPerformance.com Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations. More » |
 | Watch the recording of our latest DLM Demo webinar and learn how to improve your database change management process. See how Redgate DLM plugs into Git, Jenkins & Octopus Deploy so that you can automate your database changes alongside your application code. More » |
 | SqlBarbarian from SQLServerCentral Blogs Registered Servers I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. :-) This is definitely not... More » |
| | Arun Sirpal from SQLServerCentral Blogs I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are... More » |
|
|
| | | Today's Question (by Steve Jones): How do I enable xp_cmdshell in SQL Server 2014? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: xp_cmdshell. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database Get your copy from Amazon today. |  e |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
SENDING DAILY EMAIL ATTACHMENT WITH SQL QUERY TO GIVEN USERS. - Dear All, i would like to send out following query to all email users daily basis,can anyone guide me the direction, it...
: it works! In like way, survey that - : it works! In like way, survey that it works for women in like way, which is a stunning character boggling... Archiving Table Data - We are creating a data archive plan for one oof our big table which have more than 8 million records... MAXDOP in virtualized server in blade... - Hi, I'm remotely analyzing a SQL installation on a virtual machine in a blade server... I don't have access to the hardware...
insert a new row(s) into sql table A from table B - Hello, I am using SQL Server 2014. I have two table the first one is Table_A and Table_B. I want to copy... How do you work with multiple developers on same DB - Hi All Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare and source control....
Help understanding NC indexes and separate FileGroup - Hello All, I would like some assistance understanding something I read this morning in Grant’s book “SQL Server 2012 Query Performance... Procedure Cache Hit Ratio - Last night I just migrated one of my busiest databases from SQL 2008 to 2012. Max server memory allocated to...
Big data: transfer x-number of rows per batch? - Hi all, I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another...
Stop query if it is taking too long - Hello How can I stop the long running query that is run from application? I want to kill the queries that are... Out of memory exception - I have a stored procedure that is normally encrypted. I run this with a specific set of parameters(that I am...
Database keys - Hello, I have troubles with a table normalization assignment for university. The main problem I have is that I need to set...
time horizon financial obligations and other household duties - [url=http://www.colorado.edu/volunteer/sites/default/files/webform/btntvmichigan-vs-illinois-live-stream-waldoonline-22-oct-2016-hd-coverage.pdf]Michigan vs Illinois Live Streaming[/url] DBCC CheckDB - CHECKDB found 0 allocation errors and 14 consistency errors in database 'Test'. repair_allow_data_loss is the minimum repair level for the errors...
pervert the course of justice - [url=http://www.colorado.edu/volunteer/sites/default/files/webform/cbstvbengals-vs-browns-live-stream-paulonline-23-oct-2016-game-guide.pdf]Bengals vs Browns Live Streaming[/url] Poor execution plan within insert trigger for UPDATE to base table having primary key on identity column as the number of inserted rows varies - I have a table t1 with a primary key on the identity column of this table. Within the insert trigger...
SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier - Hey guys, i become following error during report rendering on a sharepoint intergrated ssrs mode: Fehler bei der Berichtsverarbeitung. (rsProcessingAborted) Fehler beim Ausführen...
Trump threatens to sue women - [url=http://www.colorado.edu/pts/sites/default/files/webform/%25%20ABC%20WatchESPN%21%40Strat%21NCAFF%21%21%20Ohio%20State%20vs%20Penn%20State%20Live%20Streaming%20College%20Beaver%20Stadium%20HD%20Coverage.pdf]Ohio State vs Penn State Live Streaming[/url]
USA Ships awesome and lightning rod-ish - [url=https://www.youtube.com/watch?v=l8NxYWCe5tY]New York Giants vs Los Angeles Rams Live Streaming[/url] [url=https://www.youtube.com/watch?v=OpCXUYs259g]New Orleans Saints vs Kansas City Chiefs Live Streaming[/url] [url=https://www.youtube.com/watch?v=OpZo98b8_BY]Indianapolis Colts vs Tennessee...
how to Sending Appointments to Outlook ics File-from sql server Email - how to send Email from sql server 2005 with Appointments to Outlook ics File Sending Appointments to an Outlook Calendar from... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|