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,740 reads
2011-12-06 (first published: 2010-04-14)
10,359 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,850 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 Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Gedung, Wisma Barito Pacific, Jl. Letjen S. Parman No.Kav. 62-63, Slipi, Kec. Palmerah, Kota...
Komplek, Ruko Niaga Grisenda, Jl. Pantai Indah Kapuk Jl. Kapuk Raya No.19-20 Blok GE,...
BCA KCP Kramat Jati Telp/WA0851•8812•0691 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers