By Lori Brown | Intermediate , Security , SQL Administration , SQL Server , Upgrade
–By Lori Brown @SQLSupahStah I am working with a client who is migrating from SQL 2012 to SQL 2016. It just so happens that while they have just a few databases to move, they also have a ton of SQL logins that needed to be migrated. This is not an issue since I know to […]
Continue readingBy Lori Brown | SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah SQL 2016 SP1 has been released. I might be a little late to this announcement but thought I would at least give the download link and some highlights on things that are fixed in it. Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=54276 Some of the highlights are: New CREATE OR ALTER that […]
Continue readingBy Lori Brown | Analysis Services , SQL Administration , SQL Server , Upgrade
— By Lori Brown @SQLSupahStah I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)… …and run the following: <DBCC xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah One of my clients has a rather large database with multiple filegroups and multiple database files in them. I happened to notice that a specific drive that is occupied by 2 specific files that are supposed to hold indexes is getting utilized at a much higher rate than any of […]
Continue readingBy Lori Brown | Lunch And Learn , SQL Server
Please join SQLRX’s Lori Brown and the SQLRX team at the Microsoft Campus in Irving, Texas this coming Wednesday November 16, 2016 for an informative take on reasons to upgrade to SQL Server 2016. Register Now! There are a lot of really good reasons to upgrade to SQL 2016. Even if you’re still on SQL 2008 […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah The dynamic management view sys.dm_server_registry has been around since SQL 2008 R2 SP1 so it is not new but it’s relatively new to me. Since I have a ton of SQL Servers to monitor, it is always good to have some way of easily knowing if there are any start up […]
Continue readingBy Lori Brown | Expert , SQL Administration , SQL Maintenance , SQL Server
— by Lori Brown @SQLSupahStah Recently, I was checking on some of the servers that I manage and found that one had an 8GB msdb database. While that is not too bad it is kind of large so I figured that there must be something that needed to be cleaned up. I ran the Disk […]
Continue readingBy Lori Brown | Intermediate , SQL Administration , SQL Server , Trace Flags
— by Lori Brown @SQLSupahStah Once again, I find things about SQL Server that I had no idea were even available when I actually have time to do some in-depth reading and research. Most of the time, my regular duties keep me so busy that I don’t have time to play with new SQL functionality […]
Continue readingBy Lori Brown | Expert , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Statistics are pretty important to SQL Server. Statistics are small objects that hold information of the distribution of data in a table. The SQL optimizer uses this information to create efficient ways to get data from the table. So, if statistics are not taken care of SQL may have a […]
Continue reading