Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing. The great thing about Service Broker is that its functionality is exposed so we can build our own custom data integrations. Deanna Dicken introduces you to the concepts needed to create a service broker integration.
Great DBAs collect all kinds of metrics on their instances and let them manage themselves. However many administrators need help monitoring and interpreting the data. Today Steve Jones asks if you think this data needs extra security or is it less of an issue than other PII data.
This article shows a few simple techniques to summarize table data using T-SQL.
This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated. This component is used by us to do testing of the pipeline and components downstream.
Dropbox has grown tremendously in the last few years and Steve Jones talks about a concept of running with less headroom as a way to cope with that rapid growth. Is it something you'd be interested in with a SQL Server?
SMO can be a valuable tool for working with SQL Server when you don't have access to all the tools that come with the platform. In this article, SMO helps solve an issue with a SQL Server.
Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all entities. Seth Delconte shows how to use them.
Free training in New York. Come learn about SQL Server, meet other pros, and then enjoy a night in the city.
Today Steve Jones talks about how you can find a really good job. And how you can make changes in your life to get you there.
Red Gate Software is looking to offer a new monitoring service and is looking for opinions and ideas in making it happen.
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
hi a peer of mine who ive never known to be wrong says a...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers