SQL in the City is coming to Pasadena on October 9. Register for a full day of free SQL Server training the Red Gate way. Top tips and best practices for SQL Server database development and administration will be presented by SQL Server MVP experts, including Steve Jones and Grant Fritchey. You’ll also see Red Gate tools in action and have the chance to network with other data professionals.
Allen Kinsel is running for the board of directors of PASS. He took a little time to answer some questions from Steve Jones
Looking for a new job? Want to pick the best one? Your employer probably feels the same way. Andy Warren talks about how your interview is more like dating than you think.
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
From time to time, I see a requirement to generate random identifiers for things like users or orders. People want to use random numbers so that the "next" identifier is not guessable, or to prevent insight into how many new users or orders are being generated in a given time frame, but they don't want to run into any duplicates. We can trade a bit of disk space and relatively predictable (but not optimal) performance for the guarantee of no collisions, no matter how many random numbers we've already used.
SQL Server Live! is coming to Orlando November 18-22. SQL Server Live! provides comprehensive education and knowledge share on SQL Server database management, data warehouse/BI model design, performance tuning, troubleshooting and more.
A Hyper-V replica installation provides rapid disaster-recovery by asynchronously replicating a VM running at a primary site to a replica site. Know how to prepare for something to go wrong at the Primary Server/Site? In this article Nirmal Sharma presents the Replication options for a Replica Virtual Machine with a focus on Hyper-V Failover.
When discussing SQL Server 2012 Integration Services, we have been dealing mainly with the traditional data management model, where the entire SQL Server environment resides on-premise. This once predominant paradigm is obviously changing, with hosted solutions (in the form of both private and public clouds) becoming increasingly common. In order to properly account for this trend, we turn our attention to the role that SSIS can serve in a mixed environment, where a part of the SQL Server estate is located in Windows Azure.
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp: 0817839777 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
WhatsApp: 0817839777 Jl. Suroyo No.28, Tisnonegaran, Kec. Kanigaran, Kota Probolinggo, Jawa Timur 67211
WhatsApp / CS:0817839777 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
When running bcp on Linux, what is the field terminator?
See possible answers