Viewing 15 posts - 931 through 945 (of 2,497 total)
Another way that would work is to create a report with the data you need. Then you run the report via a command line specifying it should be rendered...
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 6:22 am
It is not saying how to install Windows Installer 4.5.
It is saying how to use MSIEXEC to install a .msi file. You can get this message when you try...
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 6:16 am
You will love SQL Server 2011 when it is released. One of the new features is the ability to have multiple targets for your mirroring, and all of those...
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 2, 2011 at 2:50 am
I would go a bit beyond Steve's advice about growth.
Certainly you must add enough free space to your database to allow maintenance tasks to work. If you are doing...
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 1, 2011 at 3:49 am
I ask the individual answering where they are physically located, if not in the U.S.A .. where of course I am
This sort of assumes that if CS is done in...
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
January 31, 2011 at 4:41 am
I do not mind which parts of a business are outsourced. The key item is if they perform the function that is needed, both for the business and the...
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
January 31, 2011 at 4:09 am
The typical way of doing this is to use SQL Server as the data store, and have a separate layer of business code to do the calculations.
If the application is...
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
January 25, 2011 at 3:04 am
I had a developer uninstall\reinstall IIS and ASP.net on my production sql server.
Doing an uninstall and reinstall on a production server is a major step. I hope you did...
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
January 24, 2011 at 3:28 am
Database permissions are taken by combining all the permissions in all the groups the user is a member of. Explicit DENY permissions to a given object in a given...
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
January 18, 2011 at 4:58 am
I suppose it does mark the space as reclaimable to the OS so at some point it will be overwritten.
As GilaMonster says, if it is in the OS free space...
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
January 17, 2011 at 3:21 am
Run a secure deletion program to delete the database files securely.
You need to know how your disk subsystem works before using a program of this type. If your data...
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
January 17, 2011 at 3:15 am
Please be aware that stored procedure 'encryption' is just obfuscation. This feature was added to SQL Server way back when Microsoft could get away with mis-naming things far more...
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
January 12, 2011 at 3:05 am
Sounds like there could be more to this than I have checked...
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
January 11, 2011 at 9:29 am
If you are deploying to 32-bit then build and test on 32-bit.
If you build on 64-bit then test on 32-bit before you deploy.
If you build and test on 64-bit then...
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
January 11, 2011 at 4:54 am
I agree with Steve.
You can do the upgrades one by one (do you remember the line 'You can live on it' in Crocodile Dundee?), but I would ask...
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
January 11, 2011 at 4:48 am
Viewing 15 posts - 931 through 945 (of 2,497 total)