|
|
|
In this tip we look at a few examples of using .NET code to update and select data from SQL Server tables by creating a simple application and connection string to the SQL Server database....
|
|
|
|
|
|
In this tip we look at what a character map transformation is and how this can be used in a SQL Server Integration Services package....
|
|
|
|
|
|
Microsoft Cloud and Datacenter MVP David Bermingham will discuss best practices for moving standalone and clustered SQL Server 2008 instances into Azure to take advantage of the extended security updates for SQL Server and Windows....
|
|
|
|
|
|
Many companies rely on key applications such as SQL Server for their important business functions. Because downtime for these applications can be devastating to their business, IT typically has to meet strict service level requirements/agreements (SL...
|
|
|
|
|
|
If you are starting to learn the T-SQL language then starting with the SELECT statement makes a great deal of sense. The SELECT statement is the core command to access data in SQL Server. ...
|
|
|
|
|
|
I read in a PCI security tip that I should configure Secure Sockets Layer (SSL) encryption on our SQL Servers, but this requires a trusted certificate. In this tip we walk through the steps on how to do this....
|
|
|
|
|
|
We're looking to minimize ETL costs by importing as much data as possible using a automated system. A data provider sends us flat file data and we extract, analyze and report on these data. In this tip we look at how this can be automated using PowerShell...
|
|
|
|
|
|
What is the SQL Server Reporting Services RS.EXE utility? How can we use it with SSRS? Check out this tip to learn more....
|
|
|
|
|
