Many of you know that Brian Kelley is our resident security guy. If you didn't, this might prove it! There is a ton of information in this 63 page document worth reading. Let us know what you think.
We've asked Andy to put together some articles that tackle replication from a beginner perspective, a tutorial type approach PLUS comments on what you should or should not do. This week he covers the steps needed to set up a server for replication. More images than usual so the page may take a little longer to load, but we think worthwhile so that you can see every step along the way. Let us know what you think.
For the most part the DTC (Distributed Transaction Coordinator) just works. What happens when it doesn't? Chris had to resolve an issue with it recently and documented some of the steps he used.
In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.
Regular columnist Robert Marda had some extra time so we got him to take a look at the latest upgrade to SQL Compare - for those of you aren't familiar with it, it is a tool that will let you compare two databases to see the differences, then optionally sync one to the other.
Everyone does demos. Selling software relies upon people viewing your software in action and being confident it will work. Managing a demo server can be a challenge and this series will look at different problems and options you have.
SQL Mail comes with SQL, but you have to load Outlook to use it. The alternative is to send email directly via SMTP. Combine that idea with alerts and you've got a new article!
I bet most of us count and sum fairly often, but how often do you use the rest of the 'in the box' statistical functions? Learn these now and be ready when you need them.
The Wizard enables anyone working with a SQL Server database to identify and review duplicate data with ease. It is an exceptionally powerful tool with the modest price tag of $397 (approximately £230).
The software has a wealth of processing options, which you can read about when visiting www.findduplicates.com or (in even more detail) in the free help file download which is also available on the web site.
Joseph gathered together some various bits of code and came up with a solution that lets you do RC4 encryption via the sp_oa~ procedures.
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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 Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers