SQL University: Auditing SQL Server, Part I
Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...
2010-04-26
2,781 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
2010 Scripting Games
Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...
2010-04-21
761 reads
Thoughts on the SQL Server 2008 R2 Press Conference
If you weren't aware, Microsoft held a BI telelconference today which announced the release to manufacturing (RTM) of SQL Server...
2010-04-21
1,180 reads
PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?
In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...
2010-04-15
5,016 reads
Why I Have Had a Hard Time Adopting PowerShell
PowerShell has been out for a while. When it first came out, I went and grabbed a copy and tinkered...
2010-04-14
4,276 reads
Hosting a User Group Meeting - Day of "Bare Bones" Checklist
This actually came as a response to a tweet from Mike Walsh (Twitter | Blog). But here is the barebones checklist I...
2010-04-13
586 reads
Cloud Computing - Will Data Breaches Cost More?
That's the main point from the following article:
Video: Data breaches to cost more in the cloud
The cost was calculated per...
2010-04-09
1,029 reads
A Good Expansion on the Topic of Plagiarism
In a previous post I gave some links which help explain what plagiarism is and how to generally avoid it....
2010-04-08
659 reads
SQL University Starting Back Up
Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...
2010-04-08
739 reads
New MSSQLTips Article: Nesting Database Roles in SQL Server
I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...
2010-04-07
1,661 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers