Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
428 reads
Articles
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
779 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-21
66 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-21
523 reads
SQL Server security: Database roles
Database roles for SQL servers can increase the security of your enterprise. Understand how to set up database roles, and learn how they function.
2009-01-21
4,193 reads
Writing to an operating system file using the SQL Server SQLCLR
Reading files from the operating system can be done with T-SQL as I showed in the tip Using OPENROWSET to read large files into SQL Server. What if you want to write to an operating system file? For example, writing to a text file. There's no T-SQL that supports writing to a file.
2009-01-21
3,994 reads
Creating a Synonym for a Table - SQL School Video
New in SQL Server 2005, Synonyms replace aliases from previous versions. Brian Knight shows how they can be created and used.
2009-01-20
2,707 reads
Log Shipping Cannot Access the File
New author Brian Bitzer brings us a solution to a log shipping problem in the Real World. Read about jhow one DBA solves a contention issue using SSIS.
2009-01-20
4,153 reads
Missing row numbers
I had a request from a client who prints a lot of cheques each month and there control over the cheques went a bit haywire. The requested me to create some controls in their system to make sure that the cheques are use in cheque number sequence.
2009-01-20
1,125 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-20
774 reads
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers