Using a default account for SQL Server services can be a security risk for two reasons. Firstly, it can give the service a higher level of permissions than it needs. Secondly, isolation is compromised by several services running under the same account. This metric checks whether SQL Server services are running under any of the default accounts, such as localsystem.
2014-01-14
2,028 reads
Grant Fritchey and Steve Jones will be hosting a free seminar in Cleveland on February 7 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment.
2014-01-13
1,622 reads
SQL Saturday is coming to Albuquerque on January 25, 2014. Join us for a free day of SQL Server training and networking. This SQL Saturday also features 2 paid-for preconference sessions presented by Denny Cherry and William E. Pearson III.
2014-01-06
1,658 reads
Red Gate are looking for participants in a short short survey on SQL Server database releases. At the end you will be given a chance to enter an e-mail address to win a $50 Amazon gift certificate.
2014-01-06 (first published: 2013-12-20)
3,629 reads
As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.
2014-01-02 (first published: 2013-11-04)
17,207 reads
Voting is open for the Tribal Awards finalists. Choose which community warriors you think went above and beyond the call of duty with their blog, presentation, advice, user group, and more.
2013-12-20
497 reads
SQL Saturday is coming to Nashville on January 18th 2014. This is a free full day of SQL Server training and networking. There are also paid-for Pre-con sessions available to sign up for presented by Denny Cherry and David Klee.
2013-12-17
2,784 reads
Nigel Sammy will be presenting this PASS Data Architecture VC webinar on December 19 at 12PM CST. The webinar will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries.
2013-12-16
4,781 reads
SQL Saturday is coming to Slovenia on December 21, 2013. This is a free all-day training and networking event for SQL Server professionals.
2013-12-13
2,665 reads
Grant Fritchey, SQL Server MVP will be hosting a free seminar in Cambridge on January 10 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment.
2013-12-12
1,844 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers