You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.
2014-10-08
10,150 reads
When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.
2014-10-07
9,264 reads
To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile. TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. Edward Elliott shows you how.
2014-10-07
8,227 reads
Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.
2014-10-06
9,366 reads
Your SQL Server Report Server service will not start or you keep getting an error when you navigate to the SSRS URL? What logging tools are available to assist you with diagnosing SSRS problems, issues, or errors? Check out this tip to learn more.
2014-10-06
8,060 reads
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
2014-10-03 (first published: 2012-07-02)
27,748 reads
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
2014-10-03 (first published: 2014-09-29)
484 reads
'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs?
2014-10-03
9,305 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,700 reads
Following on from a webcast, Tim Smith answers some questions on SQL Server security like: Is It Better To Mask At the Application Level Or The SQL Server Database Level? Are there any options to find SSNs in SQL Server besides RegEx? And, why would anyone store sensitive data un-encrypted in SQL Server?
2014-10-02
8,457 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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 This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers