Database administrators have a heavy load when it comes to ensuring that their SQL Server environment complies to industry regulations such as CIS, DISA STIG, HIPAA, NERC, PCI DSS, and SOX. Join us to see the latest enhancements for SQL Server compliance
Although there are many different things that can be done to improve the performance of a database system, creating indexes is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.
Moving SQL Server from an on-premises data center to a public cloud such as AWS can enable your business to be more agile and more responsive to changing market requirements and customer needs.
If you work with SQL Server, you have probably been asked which is better, a temp table or a table variable? In this tip we look at which is faster and uses fewer resources.
The solution is to convert a SQL database into a tabular model sample by making changes in such a way that it looks as if the data model has gone through all the stages of a data warehouse and is ready to be used with a tabular analysis services...
In this tip we look at a script you can use to pull all errors from the SQL Server error log including the error numbers and associated error messages.
This tip will help you better understand what connection pooling is and provide knowledge on how to take advantage of the connection pooling mechanism when writing .NET data access code that communicates with SQL Server.
