RE: Restarting SQL Server every night
net stop mssqlservernet start mssqlserverand schedule it at windows level (at command).
2004-03-04
Comparison
RE: SQL statement help needed (2)
No, not me! But I know a friend who knows someone who has heard, that there might be some people... Actually I only thought about why always reinvent the wheel when someone else has done similar before.
2004-03-03
RE: Passing a querystring to a stored procedure?
- keep sql-injection in mind ! Check http://www.sqlservercentral.com/columnists/chedgate/sqlinjection.asp- just define your variables as sp-parameters and handle your statement in your sp. You will soon discover it's best to work with known predicates.- check http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html
2004-03-03
Blogs
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Forums
Case statement with time
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
what are the best books to become a DBA SQL?
Ask SSC