Jon Gurgul's Blog - Page 9 of 10 - Jon Gurgul with SQL Server...and occasionally something else.

List Installed Software aka Get-InstalledSoftware

I needed a script to check for installed software on local and remote machines that did not rely on the Win32_Product WMI class as this will only return software that…

Jon Gurgul 2011-12-06

Powershell

WMI Classes Via Powershell

I wrote this a while ago to bring back the contents of a particular wmi class using powershell. It was orginally only developed to have a quick look at some…

Jon Gurgul 2011-11-25

SQL Server

Time Calculations (Rounding time to 00:00 or x minute)

This is a collection of sql code to enable the removal of time from a datetime, or the rounding to the nearest x minute (up or down) The rounding includes…

Jon Gurgul 2011-10-26

SQL Server

Simple Table and Index Breakdown

This script provides a breakdown with row count and partition information of tables and indexes. It is in essence merely a cut down version of the final Detailed Table and Index…

Jon Gurgul 2011-10-19

SQL Server

Detailed Table and Index Breakdown

When I need to get a detailed overview of my database objects there are a number of scripts that I have written or adapted with varying degrees of depth. Primarily I…

Jon Gurgul 2011-10-19

SQL Server

Investigating CHECKPOINT

Investigating CHECKPOINT (Transact-SQL) Writes all dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified, but not…

Jon Gurgul 2011-09-19

SQL Server

Database Created Version or Internal Database Version – dbi_createversion

Internal Database Version Sometimes you will see references to a database with a version of 611 or 655 or similar. These numbers refer to the internal database version and have…

Jon Gurgul 2011-09-12

SQL Server

What is the easiest way to compare data in a SQL Server table and fix any differences?

Sync Table Data It is the sort of problem that you often get; you have 2 tables and you want to make sure that the data matches, however there are…

Jon Gurgul 2011-08-16

SQL Server

Please see the following resource for a complete list of updates. Where to find information about the latest SQL Server builds https://support.microsoft.com/en-us/help/957826/where-to-find-information-about-the-latest-sql-server-builds

Jon Gurgul 2011-08-02

SQL Server

What has changed in SQL 2008 R2 SP1?

Changes from SQL 2008 R2 to SQL 2008 R2 SP1 Here is my comparison of changes for the SQL 2008 R2 SP1 update. New Column(s) sys.dm_exec_query_stats http://msdn.microsoft.com/en-us/library/ms189741.aspx sys.dm_os_sys_info http://msdn.microsoft.com/en-us/library/ms175048.aspx New…

Jon Gurgul 2011-07-20