Viewing 15 posts - 916 through 930 (of 2,497 total)
If you have a SSRS report that has a multi-value parameter and you want to pass the selected values to a stored procedure in the form 'valuea,valueb,valuec' you can do...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 18, 2011 at 6:31 am
I also think that uninstall of an old SQL cluster and install of a new SQL cluster on the same Windows OS is not a safe option for a production...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 18, 2011 at 6:23 am
ilyas.info786, there is no upgrade possible for the .Net level used by SQL2005 reporting services. You may be able to use custom code in a SQL 2005 report to...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 9, 2011 at 4:01 am
I would definitely recommend installing to a new server.
It is safest to assume that any new SQL version has changes to the RS Catalog database, so do not...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 9, 2011 at 3:57 am
Unless the DBA owns the company, it is not 'his' data, it is the company data.
All company employees have a duty to do their work in the most...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 3, 2011 at 2:40 am
This is in VBScript, but is easy to port to Powershell...
Set objCluster = CreateObject("MSCluster.Cluster")
objCluster.Open ""
strClusterName = objCluster.Name
If you run this on a machine that is not...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 27, 2011 at 2:56 am
If your organisation already has a lot of experience in OBIEE and not much in SSRS, then OBIEE is probably the best choice for you. If your organisation has...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 26, 2011 at 7:20 am
Hi Santosh,
The environment you have (W2003 SBS & SQL 2000 Std) is intended for a small business on a limited budget. Having chosen this option, there are limitations on...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 26, 2011 at 5:04 am
I would also advise against renaming the sa account. It is OK to disable this account, but as UMG Developer said some things (sometimes this includes a service pack...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 5, 2011 at 4:19 am
There is a similar thread active on SSWUG.org, and Marc has given an excellent response on 4 March:
I’m assuming the person who posted the question has built an application and...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 7, 2011 at 6:28 am
You can do this, but it is not recommended that you add SQL 2008 to a production server that is already in use with SQL 2005. If you are...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 7, 2011 at 6:22 am
Going back to the question about optimum page file size, I wish Microsoft would officially update their advice. There are a number of posts from PSS engineers that say...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 2, 2011 at 4:54 am
As far as I know, it is not possible to put an encrypted password in any process that automates a SQL Server install.
An alternative might be to pass the password...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 2, 2011 at 4:43 am
Fantastic idea! Now to manage my time to read them...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 28, 2011 at 7:35 am
There is a way to get a new grace period...
1) Ensure all your user databases are not on the system drive
2) Script out everything you might need from your system...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 28, 2011 at 7:30 am
Viewing 15 posts - 916 through 930 (of 2,497 total)