Linked Server Tribulations In SQL Server
In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.
2014-08-05
5,914 reads
Articles
Call for Speakers - SQL Saturday Pittsburgh
SQL Saturday #315 in Pittsburgh (Oct 4th) is looking for speakers - if you've got a SQL topic you want to talk about, submit it and you may get to share with your peers.
2014-08-05
8,910 reads
How to test what a SQL Server application would do in the past or in the future with date and time differences
For date and time based testing, I use what I like to call "mock-time". The mock-time starts at what ever I set it to, but then advances along with the regular system clock. Andy Novick shows how that would work.
2014-08-05
9,532 reads
SQL Monitor Custom Metric: Schema Modified
This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.
2014-08-05
8,628 reads
Technology Wave
The quickness at which technology has and is changing our lives and shaping our culture.
2014-08-04
63 reads
Call for Speakers in Sunny San Diego
If you're in Southern California, you should come to SQL Saturday #340 and speak at their event. If you want a late summer vacation, submit and come enjoy the event.
2014-08-04
8,341 reads
Managing Big Data DBAs
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?
2014-08-04
10,972 reads
How To Write An Interview Winning Resume
Writing a resume that rocks is not an art. Follow these simple guidelines to help secure your next interview.
2014-08-01 (first published: 2012-07-19)
19,783 reads
Create First SSRS Report with SQL Server Analysis Services OLAP Cube
Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.
2014-08-01
12,428 reads
Spackle: Making sure you can connect to the DAC
The DAC is an important tool and several things can go wrong when trying to connect to it.
2014-07-31
3,293 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
How Accounting Assignment Help Improved My Academic Performance
I recently used accounting assignment help, and it made a huge difference in my...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Question of the Day
Identities and Sequences III
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