I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?
The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.
You have a few options for protecting your SQL Server data at rest. So far I haven't seen anything thing protects data in memory, and I'm not sure we ever will. After all, at some point it needs to be processed, joined, etc., and that can't happen if it's well encrypted.
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.
MVP Brad McGegee spends a lot of time talking to people at Microsoft. He's learned how to interpret thier language, and understand what they mean when using certain terms.
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine.
What happens to the data of a company if it goes out of business? Steve Jones has a little experience and says it might not be as simple as you think.
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers