SQL Server Security Benchmarks
If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...
2014-10-20
867 reads
Blog Posts
2014-10-20
9 reads
2014-10-20
3 reads
2014-10-20
2014-10-20
3 reads
Webinar: Presenting to the PASS Database Administration Virtual Chapter
In this Webinar, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a...
2014-10-20
802 reads
My Best LinkedIn Articles
Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.
7 Bad Management...
2014-10-19
581 reads
Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP...
2014-10-17 (first published: 2014-10-13)
15,949 reads
Friday Followup For October 17, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-17
421 reads
Navel Gazing
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,594 reads
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
How to market your book on Amazon?
Marketing a book on Amazon really comes down to combining smart optimization with consistent...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers