This week Steve Jones wants to know if you can find time for your professional development. Regularly improving your skills is an important part of your career in technology, and the poll this weeks asks what time you can make for improvement.
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.
Performance test of new SQL 2012 functions DateTimeFromParts and Format
Steve Jones attended a day out from the Red Gate offices recently and he talks about the value of those experiences.
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort.
Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)
Amazon now offers SQL Server 2008 R2 in their RDS service. It's an easy way to get working with SQL Server with a minimal investment.
Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats
SQL Server Reporting Services provides several ways to analyze the data; a few of them are creating reports with indicators and Gauges. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent the state value of Key Performance Indicator (KPI, a measurable value which has business significance with a specific target or goal that indicates whether things are going good or bad).
An outage at SQLServerCentral reminded Steve Jones that it's not "if" a disaster will occur, but "when" it will occur that should have you preparing for a disaster at some point in the future.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers