SQL Server on 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.
2012-05-09
288 reads
Editorials
The Colocated Dangers
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.
2012-05-08
112 reads
Mobile Password Protection
Security is becoming more of an issue for mobile devices as we store and access more information on them all the time.
2012-05-07
93 reads
Responsibility for Security
Steve Jones talks about security, and the developer's role in ensuring secure code.
2012-05-07
337 reads
The Best Way to Learn
This Friday Steve Jones is looking to see how you might like to improve your educational materials. With the success of our Stairway Series, we are looking to find better ways to teach people about SQL Server.
2012-05-04
317 reads
Learn XML
Steve Jones talks about XML and how it will be more and more important for DBAs to understand this in the future.
2012-05-03
718 reads
Being Responsible for Code
How responsible should developers be for their code? Facebook has an interesting way of looking at their engineers' performance.
2012-04-30
264 reads
When Will You Upgrade to SQL Server 2012?
Having noticed a very low rate of migration to the latest version of SQL Server, Brad McGehee asks - when will you upgrade to 2012?
2012-04-30
723 reads
Security Outside the Database
Database security needs to improve, and while SQL Server continues to get better, there is more work to do. However there are plenty of security issues outside the database that also need to be addressed.
2012-04-26
174 reads
Technology for Sharing
Technology has been great for helping us work more efficiently by better sharing resources. Steve Jones sees this as both good and bad in different ways as well as a way of providing new opportunities.
2012-04-25
67 reads
Blogs
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers