SQL Server does not support source safe control as the .NET application does. However, utilizing DDL trigger events makes it possible to capture when database users, ether one DBA or Developer, create, alter and drop the SQL Server objects. This session demonstrates the complete solution on how to set up SQL Server source safe control, log any changes and roll back to any historical point of changes.
Alex will be selling signed copies for $30.00 of his new book XML and JSON Recipes for SQL Server A Problem-Solution Approach
Interested in using the Cloud for SQL Server? Wondering what is the cloud? Come find out what Cloud Computing is all about and why you might want to use it. We’ll introduce Microsoft’s Cloud, Azure, and talk about how it can be used for *FREE*! We’ll demonstrate creating Virtual Machines in the cloud that can run SQL Server (just like on premises) and we’ll also demonstrate creating SQL Servers in the Cloud using SQL Azure (no virtual machines required).
No need to be afraid of availability groups. No more multi-subnet clusters. Use DAG to implement cross cluster replication. Learn how to expand your replication using the distributed availability groups using virtual and physical servers. Configure solutions to provide high availability and disaster recovery to any degree.
There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.
How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.
In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it's calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it's useful to be able to look back in time through our data. Starting in SQL Server 2016, system-versioned tables provide a solution that tracks data through time with far less overhead than previously offered solutions. This session will cover the basics of system-versioned tables, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. We will also cover the mechanics of data retention and storage and archival of historical data. Attendees will leave with a fundamental understanding of practical use cases for system-versioned tables and the knowledge required to implement them successfully.
When In-Memory OLTP was originally introduced it seemed to be the answer to all our problems. No locking! No latching! 100x performance gains! But just as there is no spoon, there is no silver bullet with SQL Server, and In-Memory is not a quick-fix for every scenario. But it *could* be a solution for your environment. How do you know? That's what we'll talk about in this session. We'll discuss the basics of In-Memory and then cover topics such as candidate workloads, figuring out what to migrate, and testing methods that you can use to determine if it really does provide a performance boost. Along the way we'll clear up any misconceptions you have about In-Memory OLTP, and you'll walk out of the session knowing whether this is something you should pursue, or put on the back burner until the right opportunity comes along.
• What we'll do
In this session we'll cover ten things I think everyone ought to know about SSIS. I'll touch on performance, a few best practices, and mention BIML at least once.
• What to bring
• Important to know
Title - Managing SQL Server on a Tight Budget
Abstract - If you are a good SQL Server Database Administrator, you know that there are best practices on how to manage a SQL Server environment in a company. But when you have a very limited budget there are some situations on which you can’t comply with best practices, yet you are still responsible for keeping the servers up and running.
Disk Space Issues Strategies: When the free space is not enough.
> Shrinking files to release space.
> Moving data between data files.
Consequences on Log Files of shrinking.
> Excessive VLF in Log Files.
> Performance Impact on ETL Process.
> Identifying the Effects caused on SQL Server when the Hypervisor doesn’t give resources.
ETL Processes Migration.
> Importing Mainframe Data with SQL Server Integration Services (https://www.mssqltips.com/sqlservertip/3438/importing-mainframe-data-with-sql-server-integration-services/).
> Export SQL Server Data with Integration Services to a Mainframe (https://www.mssqltips.com/sqlservertip/3535/export-sql-server-data-with-integration-services-to-a-mainframe/).
> Importing Mainframe Data including Packed Numbers with SQL Server Integration Services (https://www.mssqltips.com/sqlservertip/3459/importing-mainframe-data-including-packed-numbers-with-sql-server-integration-services/).
Speaker - Daniel Farina
Sponsor - MSSQLTips.com
MSSQLTips.com (https://www.mssqltips.com/) is a free community dedicated to SQL Server. Since 2006 our team has delivered value to millions of SQL Server DBAs, Developers and Business Intelligence Professionals on a daily basis. MSSQLTips.com helps solve real world problems and improve your SQL Server knowledge with free tips, tutorials, web casts, videos and more. The MSSQLTips.com team is comprised of 150+ expert authors (https://www.mssqltips.com/sql-server-mssqltips-authors/) led by Greg Robidoux (https://www.mssqltips.com/sqlserverauthor/37/greg-robidoux/) and Jeremy Kadlec (https://www.mssqltips.com/sqlserverauthor/38/jeremy-kadlec/). We are focused on sharing knowledge and improving the global SQL Server community every second of the day. >>> Join today! (https://www.mssqltips.com/get-free-sql-server-tips/?ref=BSSUG)