In this webcast, we will review indexing strategy for your important queries, understand new features in indexing like resumable index creation in SQL Server 2019, and talk about some underutilized features like data compression.
In this tip we look at a T-SQL script you can use to quickly find the last time the server was rebooted and also the last time the SQL Server service was restarted.
In this tip we look at how to estimate the cost of running SQL Server on AWS RDS. We look at edition, machine size, IOPS and more to help you get an idea of the costs of using AWS for SQL Server.
In this tip we look at a script that gives a quick overview of SQL Server configuration settings like memory, parallelism, version, edition, patch level, etc.
One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.
In this tip we look at different SQL Server date functions to assist with getting beginning and ending periods such as first day of month, first day of quarter, etc.
In this tip Koen Verbeeck shares things he has learned over the years related to business intelligence that he wish he knew when he first started working with SQL Server.
Learn how to simplify enterprise application integration with JAMS including coordinating business processes, code management, security, monitoring and more.
In this tip you will learn a couple of different ways to populate a hierarchy with the hierarchyid data type. You will also gain some exposure to a subset of methods of the hierarchical data type.
In this article Scott Murray covers some lessons learned over the years when working with SQL Server Reporting Services that he wish he knew when he started with SSRS.
