Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there and I should really get on a start using them but never *quite* have a compelling enough reason.
2011-12-08
1,538 reads
It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What to do about it? Read on!
2011-12-08
3,222 reads
Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?
2011-12-07
3,950 reads
We’d like your thoughts on what new features should go into our backup tools. Let us know by completing this short survey.
2011-12-07
1,933 reads
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
2011-12-06
7,738 reads
2011-12-06 (first published: 2010-04-14)
10,358 reads
What do SQL joins and the "teach a man to fish" Chinese proverb have in common? SQL joins, like regular expressions, are one of those commonplace programming tasks in which true success is entirely dependent upon your ability to conceptualize the outcome. Fail to do so and you'll likely wind up spending a few hours in a frustrating round of trial and error. Like regular expressions, the proliferation of online examples has actually contributed to the frustration, providing the equivalent of a day's worth of fish rather than the proverbial fishing pool.
2011-12-06
4,896 reads
This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.
2011-12-05
7,795 reads
FatherJack shows you how to check that your alerts and notifications are linked up so that when an Alert condition is met that you get the appropriate Notifications sent to Operators.
2011-12-05
2,306 reads
SQL Test is a new unit testing plug-in which allows you to seamlessly write, run and manage tests within SQL Server Management Studio. Download the preview release now.
2011-12-02
3,045 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Comments posted to this topic are about the item Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers