TDE Setup and Administration Scripts
A comprehensive set of scripts to setup and operate TDE for a SQL Server.
2012-08-10 (first published: 2011-03-08)
38,875 reads
Articles
Regular Expression Transformation
The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. The way multiple columns are handled can be set on the options page.
2012-08-10
3,946 reads
SQL Server 2012’s Information on Parallel Thread Usage
In the SQL Server 2012 execution plan we can see better the true thread reservations for a query and not just information on the maximum degree of parallelism and row distribution across parallel threads; thanks to the new parallel thread usage information.
2012-08-09
5,768 reads
Removing the SQL Server Management Data Warehouse
SQL Server 2008 introduced a new feature, Management Data Warehouse (MDW), which allows users to collect metrics on their servers over time to aid in performance troubleshooting. A lot of people try this feature out, because it is easy to set up, and then find that it is not so easy to remove. In fact, removing MDW is not supported; in SQL Server 2012, though, a new system stored procedure was added to make this process easier. The problem is that this stored procedure (as well as several of the workarounds I've seen published) can leave several objects behind.
2012-08-09
2,418 reads
SQL Saturday #164 - Cleveland
A free day of training in Cleveland, OH. Come see MVPs Allen White and others talking about all aspects of SQL Server. For free.
2012-08-08
1,631 reads
Working with SSIS Data Types
In order to be able to take data from a variety of sources, manipulate it, and then export it to one of several destinations, SSIS has to use its own data types. If you hit problems, then you may need to intervene to ensure an appropriate conversion.
2012-08-08
3,143 reads
Display data by fiscal year instead of calendar year
This article provides a simple solution to display any data by fiscal year instead of calendar year.
2012-08-07
5,797 reads
Optimizing tempdb configuration with SQL Server 2012 Extended Events
One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the allocation bitmap of each data file used. We can use one of the rules-of-thumb to choose what should be roughly the best number of files, but how then do you check to see whether you've got it right for your data and workload?
2012-08-07
2,869 reads
Code Reviews Must Be Brutally Honest
Today we have a guest editorial from Hakim Ali. Today Akim talks about why holding back out of politeness in code reviews may be a self-defeating practice.
2012-08-06
363 reads
Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL
Managing log files in a large enterprise environment can be an overwhelming task. In this article I will show you how to automate some of the work using SQL Alerts and Powershell 2.0
2012-08-06
2,793 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Saharjo Hub.0851•8812•0691
BCA KCP Saharjo Hub.0851•8812•0691 Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota...
BCA KCP Santa Hub.0853•5504•2311
BCA KCP Santa Hub.0853•5504•2311 Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta...
BCA KCP Boulevard Timur Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Boulevard Timur No.54-55 Blok NC 1, Pegangsaan Dua, Kec. Klp. Gading, Jkt...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers