 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Improving Replication I really like replication as a technology. I think the ability to move data around to other systems, at a gross level, is extremely handy in many systems. While SSIS and other ETL tools are very flexible and powerful, they also require quite a bit of work to maintain. Being able to send a table (or a vertical/horizontal partition) to another system is just valuable. This is why I'm constantly disappointed that SQL Server hasn't really bolstered their replication technologies to make it more robust. Don't get me wrong, there have been improvements in various versions, and replication has come a long way since SQL Server 6.5, but as an overall subsystem in SQL Server, it has a long way to go. The tooling needs work, the reliability and robustness needs work. I find replication brittle, as do many others, and when there are code deployments needed, it seems that administrators often just script out the system, tear it down, make changes, and rebuild it. That's not a great plan. In 2017, that shouldn't be the plan. I don't get why Microsoft hasn't made things better, after all, more replication options could mean more SQL Server instances installed to support disparate workloads. However, rather than complain, I'd like to give Microsoft ideas. Today I'm curious. What would you do to improve replication? What would you like to see? Perhaps you want better monitoring of the process. Simpler setup, such as that available in Azure. Better bidirectional replication? Maybe an easier way to deploy changes? Let us know your ideas for improving SQL Server replication. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 2.4MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | State of Database DevOps Report Learn how teams are extending DevOps practices to SQL Server databases. Get the report |
|  | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | |  | Kenneth Igiri from SQLServerCentral.com How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points More » |
 | Additional Articles from SimpleTalk Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release. More » |
 | Kenneth Fisher from SQLServerCentral Blogs I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column ‘xyz’... More » |
| | Grant Fritchey from SQLServerCentral Blogs I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume,... More » |
|
|
| | | Today's Question (by Steve Jones): I want to disable database mirroring from the mirror server. When I try to access the properties of the mirror database, the selection is grayed out. From T-SQL, how do I disable the mirroring session for me Sales database on the SQL01 instance in SQL Server 2016? |
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: Database Mirroring. 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 |
| Yesterday's Question (by Steve Jones): What are the options for protecting the encryption key used by a native encrypted backup? In other words, what is my encryptor for the backup key.
Answer: An asymmetric key or certificate Explanation: An asymmetric key or certificate can be used. Ref: Backup Encryption - click here
» Discuss this question and answer on the forums |
|
|
| | | Rajbir Khehra from SQLServerCentral.com This query will help you to fetch the information from Send MAil Task(To,CC,BCC,Subject) in SSIS packages.It also fetch the data for those tasks which are inactive. More »
|
|
|
| Database Pros Who Need Your Help |
| | |
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|