Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-08
6,186 reads
Blog Posts
Transaction replication info
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
733 reads
Windows 7, UAC, and SQL Server
This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working...
2009-09-08
375 reads
Expense Reporting
I got a $25 app card with my iTouch, and forgot about it. However when we had guests over last...
2009-09-07
471 reads
MIF Busters
Management Information Format (MIF) files are formatted text files containing additional information about hardware and software components. The MIF format originated...
2009-09-07
1,597 reads
Running with more permissions
Recently someone was asking how they could execute some ALTER DATABASE commands without requiring sysadmin permissions. This person's company didn't...
2009-09-07
350 reads
SQLPSX Developer Blog
Powershell enthusiast, DBA and new SQL Server PowerShell Extensions developer Mike Shepard started a blog. Mike addresses a common question...
2009-09-07
488 reads
Uploading a List of Names For a LinkedIn Group
It’s been a couple months since we set up the OPASS group on LinkedIN and we’ve had some people join,...
2009-09-07
292 reads
Workaholics Anonymous – Providing A Development/Deployment Management Template on Labour Day
As mentioned by Phil Factor during the previous post’s comments regarding an example disaster recovery template/plan, and to keep in...
2009-09-07
1,929 reads
Tampa Code Camp Date Announced
The next Tampa Code Camp will be Nov 7th, 2009 at the KForce Building in Tampa. For the first time...
2009-09-06
307 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers