Archives: January 2012
The question came up, what are the top 3-5 things that you look at in a query. I realized then that I hadn’t really written them down. There are some areas that let me know pretty much immediately where problems lie within a plan. You don’t necessarily know the answer… Read more
The call for applications is open today, a chance for six lucky people to do more in the SQL community for a year. Idera will sponsor your travel to a few events in the US, invite you to do webcasts that often have 1000+ attendees, and work with you to… Read more
Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when SQL Server starts up as well as what jobs are set to run when SQL Server Agent comes online. An attacker could use both of these places to embed code to regain… Read more
0 comments, 603 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 January 2012
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base tables in that article. Today, I want to dive into these tables a little bit more.
Following on from the first post in my blogging series Building a Blog I’m just going to take a quick look at some of the blogging platforms you can choose to manage your blog. The most common platform that I have come across if WordPress. I haven’t really used… Read more
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16, State 1, Line 17 : Conversion failed when converting the nvarchar value '??u? ? ? ?AA???????????W?????????a??????K???????????????????1217' to data type int. [SQLSTATE 22018]
It was necessary to create… Read more
FB Friend: Hi
I : Hi
FB Friend: I need your help
FB Friend : My SQL Server is not starting...
I : What is an error you…
2 comments, 1,481 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 29 January 2012
This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery (blog | twitter) did a nice session on powershell for n00bs and it got me thinking that I need to start posting some of my powershell stuff up… Read more
Find Login in AD
Many times we require to know if particular login is a part of ad user group. Or sometimes we need to know a AD group and wanted to know who all logins are part of it.
There are many different ways to achieve this.
One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in a topology. In an earlier post I demonstrated how to handle conflicts using the business logic handler framework - now I would like to show how to create Merge Replication… Read more
I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a few comments about the experience.
Setting up a petition was very easy and they do a good job of walking you through the process. The total time is… Read more
The second round of #meme15 finished up last week and it’s time to see who participated. In total, there were fifteen people that participated in the event. If I’ve missed anyone, just leave a comment here and I’ll update this post.
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if you run into something similar:
A data warehouse has an advertising table that has these four fields: Product Type, Inches, Lines, Pieces. The Inches, Lines and Pieces fields… Read more
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may not have had a chance to see. Also a chance to bring back to the forefront posts that some may have seen but forgot about.
If you have… Read more
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY and PASTE from a Excel spreadsheet into Access , which then updated SQL Server. Upon asking him , why he used this method , he said “It’s the way… Read more
I took an interest in building a blog/website several years ago when I first started my company and working for myself. Over the years I have tried many different approaches and over the last few years I have settled on using my blog to build my brand.
More recently a… Read more