Do you really know who has access to your SQL Server database? With data breaches becoming more common, DBAs must be proactive in verifying and controlling what access permissions are assigned to database users. Join us to learn how to effectively manage
I am updating my table statistics nightly, but I am still seeing occasional poor performance with some of the queries being executed against my database. We will look at whether statistics could still be an issue.
Microsoft SQL Server Extended Events, a replacement for SQL Trace, provides a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. However...
I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement
My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server? In this tip we walk through how you can query Active Directory fro
You want to make your SQL Server Reporting Services (SSRS) Tablix's and Matrix's more attractive by configuring an alternative row background color. Unfortunately, you cannot find any out of box properties in SSRS to do this. How do you configure alternat
Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups in this
We have SQL Server replication configured on our servers and every once in a while we find the SQL Agent replication jobs are stopped and data is not being replicated. We can find the status of the replication agents either using replication monitor or t
I noticed that when some queries run a lot of transaction log space is utilized. Can you explain how the transaction log gets used and why it doesn't always free up space after issuing transaction log backups.
On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.
With the release of SQL Server 2016, there have been some changes in the security model for groups and/or users for Master Data Services (MDS). New roles have been added and the granularity of permissions has been modified.
SQL Server vNext CTP 1.1 has been released. This CTP has some interesting enhancements for SSAS Tabular. In order to try these enhancements, one may want to port their existing SSAS solutions or create a new SSAS solution in the SSAS vNext.
I have been asked to provide better visibility into what's going on with my SQL Servers for security audits and other regulation guidelines. In this tip I cover how to use SQL Compliance Manager to do just that.
I have some sales forecast data that I get from the business users in an Excel spreadsheet. I need to load this data into a SQL Server database table. The forecast contains product categories on the rows and the sales forecast for each month is on the c