-
Archives
- November 2023
- July 2023
- June 2023
- March 2023
- February 2023
- October 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- June 2021
- May 2021
- March 2021
- February 2021
- November 2020
- October 2020
- September 2020
- August 2020
- July 2020
- June 2020
- April 2020
- March 2020
- February 2020
- January 2020
- December 2019
- November 2019
- October 2019
- September 2019
- July 2019
- June 2019
- April 2019
- March 2019
- February 2019
- January 2019
- December 2018
- November 2018
- October 2018
- September 2018
- August 2018
- July 2018
- June 2018
- May 2018
- April 2018
- March 2018
- February 2018
- January 2018
- December 2017
- November 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- January 2017
- December 2016
- November 2016
- October 2016
- August 2016
- July 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- January 2015
- November 2014
- October 2014
- September 2014
- August 2014
- June 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- April 2013
- March 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- February 2012
- November 2011
- October 2011
- August 2011
- July 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- August 2010
- June 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
-
Meta
Category Archives: SQL Server
Linkdump: SQL Server security through ActiveDirectory Groups, ConnectionString encryption
I swear I have a post or linkdump on this. Log now, search later! Securing SQL Server using ActiveDirectory: https://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-practice/ https://serverfault.com/questions/457798/why-does-a-d-account-need-sql-server-login https://security.stackexchange.com/questions/98247/ad-user-vs-sql-user-for-sql-server-authentication https://dba.stackexchange.com/questions/12453/login-to-sql-server-using-windows-authentication Connection String encryption: https://msdn.microsoft.com/en-us/library/89211k9b(v=vs.110).aspx Some may think that it’s hard to cheap viagra pfizer put together an … Continue reading
Posted in Linkdump, SQL Server, System/DB Administration
Leave a comment
SQL Server linkdump: Create login, Relocate database and best practices, corruption repairs
https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=sql+server2016+create+new+login&* https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login http://www.quackit.com/sql_server/sql_server_2014/tutorial/sql_server_user_logins.cfm https://www.supremainc.com/en/node/618 https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=moving+a+database+from+one+drive+to+another+detach+database&* http://dba.stackexchange.com/questions/52007/how-do-i-move-sql-server-database-files https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=ozar+how+to+requisition+drives+for+sql+server&* An English doctor named Edward Jenner first discovered that the development of tablets for erectile dysfunction started in the middle of the nineteenth century. recommended cheap tadalafil tablets … Continue reading
Posted in Linkdump, SQL Server
Leave a comment
SQL Server: time zone adjustment that accounts for Daylight Saving Time changes
This pulls the calendar for Daylight Saving Time from the server. DECLARE @time_in DATETIME SET @time_in = GETDATE() — SET @time_in = ‘2016/10/15 09:20:00 pm’ DECLARE @timezone_adjustment INT SET @timezone_adjustment=DATEDIFF(hh,GETUTCDATE(),GETDATE()) Since an erection depends on unimpeded blood flow to reach … Continue reading
Posted in Programming, SQL Server
Leave a comment
Linkdump: SQL Server authentication credentials, users, and logins
Google “best practice for sql server logins”: https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=best%20practice%20for%20sql%20server%20logins Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server https://support.microsoft.com/en-us/kb/2028697 Google “how to set up users and logins sql server”: https://www.google.com/search?q=how%20to%20set%20up%20users%20and%20logins%20sql%20server Best practice on users/roles on SQL Server for a web application http://stackoverflow.com/questions/1395278/best-practice-on-users-roles-on-sql-server-for-a-web-application … Continue reading
Posted in Linkdump, SQL Server, System/DB Administration
Leave a comment
SQL Server trigger to detect who uses sa login
Note to self: Implement this But, in each of his five best-selling books, Oz as dedicated a portion to new order generic levitra concepts that are really old concepts. Consulting a doctor will let you know whether you actually need best … Continue reading
Posted in SQL Server, System/DB Administration
Leave a comment
SQL Injection cheat sheet
https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/Pulmonary hypertension leads to exercise intolerance which can progress to heart http://twomeyautoworks.com/item-3537 generico viagra on line failure. Such miscommunication during online cialis mastercard you can try these out sexual functioning could cause ED. As we end order levitra online this … Continue reading
Posted in SQL Server
Leave a comment
Save a null value to a GUID field using C# SqlParameter
sCommand.Parameters.Add(“@employee_id”, SqlDbType.UniqueIdentifier).Value = (processEmployee_id == String.Empty ? System.Data.SqlTypes.SqlGuid.Null : new Guid(processEmployee_id)); In order to obtain safe and long term solutions, Ayurveda offers excellent, effective, and no side effects people generic levitra online glacialridgebyway.com prefer to take only VigrX male … Continue reading
Posted in C#, Programming, SQL Server
Leave a comment
Creating unique constraints via SSMS
To create a unique constraint Canadian Pharmacy Online Saves Money buy viagra online http://downtownsault.org/crooked-music/ Buying prescription drugs from a Canadian pharmacy online can save you as much good as quitting smoking! More energy! Regular exercise may actually give you more … Continue reading
Posted in SQL Server, System/DB Administration
Leave a comment
SQL View to produce descriptive one-parameter date ranges
Automatically generated date ranges by name. Year-to-date? Last month? Next month year-to-date? Make sure to have the authentic product viagra soft tablet to assure the top quality of the results. Something else is this medication of generic levitra pill must … Continue reading
Posted in Programming, SQL Server
Leave a comment
SQL Server wait states
The SQL Server Wait Type Repository… http://blogs.msdn.com/b/psssql/archive/2009/11/03/the-sql-server-wait-type-repository.aspx Wait Stats @ BrentOzar.com Safety Precautions for Kamagra Although cheap, Kamagra is perfectly safe for consumption. levitra prescription on line Stress, heart disorder, informative web-site viagra usa price depression and high cholesterol are … Continue reading
Posted in SQL Server, System/DB Administration
Leave a comment