MS SQL Server – epm.jonhwilliams.com http://epm.jonhwilliams.com i build custom EPM systems that work Mon, 18 Jul 2016 22:14:12 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 SQL Server tuning http://epm.jonhwilliams.com/sql-server-tuning/ http://epm.jonhwilliams.com/sql-server-tuning/#respond Mon, 18 Jul 2016 22:14:12 +0000 http://epm.jonhwilliams.com/?p=483 If SQL Server is part of your kit, this will be interesting:

“If you do a lot of query and index performance tuning, you’re going to love the improvements in this month’s release of the First Responder Kit.”

First Responder Kit is from Brent Ozar Unlimited® via @BrentOzarULTD

 

]]> http://epm.jonhwilliams.com/sql-server-tuning/feed/ 0 simplify SQL Server installation http://epm.jonhwilliams.com/simplify-sql-server-installation/ http://epm.jonhwilliams.com/simplify-sql-server-installation/#respond Thu, 10 Mar 2016 17:12:30 +0000 http://epm.jonhwilliams.com/?p=471 “SQL FineBuild makes it easy for anyone to produce a best-practice installation and configuration of SQL Server.

“Simplify the time needed to deploy any of the following builds:

“Main Instance Server Build – for multi-drive servers (clustered or non-clustered)

“Additional Named Instance Server Build – adds another SQL Server instance to a server

“Workstatiodrive[sic] desktop machines

“Client Tools Only Build – just the tools, to allow remote administration of SQL Server

“There are five members of the FineBuild family:

  • SQL2016 FineBuild to install SQL Server 2016
  • SQL2014 FineBuild to install SQL Server 2014
  • SQL2012 FineBuild to install SQL Server 2012
  • SQL2008R2 FineBuild to install SQL Server 2008 R2
  • SQL2008 FineBuild to install SQL Server 2008
  • SQL2005 FineBuild to install SQL Server 2005

“All of these can be downloaded at FineBuild V3.2.1”
source: http://sqlserverfinebuild.codeplex.com/

steps

http://sqlserverfinebuild.codeplex.com/documentation

 

external links

Source for this is the original author in a SQL Server Central post about replication.
Get more information about FineBuild from discussions on CodePlex.

 


]]> http://epm.jonhwilliams.com/simplify-sql-server-installation/feed/ 0 search for string in every table and field – SQL Server http://epm.jonhwilliams.com/search-every-table-and-field-in-a-sql-server-database/ http://epm.jonhwilliams.com/search-every-table-and-field-in-a-sql-server-database/#respond Sun, 18 Aug 2013 06:44:26 +0000 http://epm.jonhwilliams.com/?p=186 SQL Server: Search Every Table And Field

An important query to have in your toolbox will search through tables and fields.
One may Set a search string.
One may Create a stored procedure.

steps

Follow the external link.
Copy.
Follow the instructions.

description

There are times when getting granular on the backend is a good thing.

external links

Search every table and field in a SQL Server Database Updated | Tim Gaunt.


]]> http://epm.jonhwilliams.com/search-every-table-and-field-in-a-sql-server-database/feed/ 0