• SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video

    Updated: 2012-02-29 01:30:51
    Today is February 29th. An unique date which we only get to observe once every four year. Year 2012 is leap year and SQL Server 2012 is also releasing this year. Yesterday I wrote an article where we have seen observed how using four different function we can create another function which can accurately validate [...]

  • Unorthodox DBA Kits

    Updated: 2012-02-29 01:08:03
    I get some strange looks from people when they see what machines I use in my DBA life. First it was because I was using a personal MacBook Pro. In the past few days, it’s because I’m not using it any longer. I still love the MBP, but so does my wife, and she, rightfully, didn’t love the idea that I was hogging it all the time. Now the MBP has returned to its quiet life at home, and I have a new Tablet with a touch UI for work. That was a huge change for me, because it’s the first PC I’ve ever bought....(read more)

  • Why people think some SQL Server 2000 behaviors live on... 12 years later

    Updated: 2012-02-28 16:57:00
    A long, long time ago in a galaxy you can reach out and touch right now, ORDER BY in a VIEW meant something. If you had a view like the following: CREATE VIEW dbo.Rubbish AS SELECT TOP 100 PERCENT Trash FROM dbo.Garbage ORDER BY Trash ; And then you ran a query such as: SELECT Trash FROM dbo.Rubbish ; You could reliably expect the rows to come back ordered by Trash in ascending order, even though it is relatively clear that the ORDER BY here serves a completely different and overloaded purpose -...(read more)

  • Unfairly forgotten partitioning views can help us make our partitioning tables design better

    Updated: 2012-02-28 08:12:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Maria Zakourdaev Entire Site Search Home Blogs Downloads Opml Maria Zakourdaev The only thing worse than being talked about is not being talked about . Oscar Wilde Unfairly forgotten partitioning views can help us make our partitioning tables design better Partitioning is a very important feature for scalable applications , it allows breaking up huge monolithic tables in order to ensure their scalability manageability within a single instance . For example , data deletion and loading can be very fast if done by partition . Reorganizing , optimizing and rebuilding indices also can be done by partition which is much less intrusive and . faster Also , when talking about

  • SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function

    Updated: 2012-02-28 01:30:08
    Note: Tomorrow is February 29th. This blog post is dedicated to coming tomorrow – a special day :) Subu: “How can I find leap year in using SQL Server 2012?“ Pinal: “Are you asking me how to year 2012 is leap year using T-SQL – search online and you will find many example of the [...]

  • Create a #dax Measure in a Session in #BISM #Tabular

    Updated: 2012-02-28 00:47:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SQLBI Marco Russo Entire Site Search Home Blogs Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server Create a dax Measure in a Session in BISM Tabular Thanks to Greg Galloway that pointed me out this is possible , in this post I want to show how to create a measure local to a session . This could be done in SQL Server Management Studio , even if it is probably not so useful for a Tabular model considering that you can easily define measures local to a DAX query . However , maybe you will have a reason to do that I can only imagine a long list of measures defined in a session that are used in small queries sent

  • Bad Habits to Kick : Believing everything you hear or read

    Updated: 2012-02-27 18:52:00
    I read a statement on a forum recently that said something like: IDENTITY columns are the primary key, and primary keys are clustered. Wow. My first thought was, "I hope people aren't learning from this." Unfortunately, I suspect a few already have, as no matter what you write on the Internet or say in passing, at least one person is going to believe you. I suspect the statement above came from someone's opinion, based on seeing a handful of tables in their life, which always had an IDENTITY column...(read more)

  • Write something awesome, no one sees it. Write something embarrassing, everyone sees it.

    Updated: 2012-02-27 15:52:00
    Hi everyone, I am truly exited to start blogging here among this incredible #sqlfamily. My name is Maria Zakourdaev. I have more than 10 years experience with SQL Server. The last five years have been spent mostly on benchmarking different SQL Server features and flows, like replication, data import, indexes impact on DML flows, star transformations in RDBMS, Hierarchic queries and custom OLAP-like aggregations. I was a speaker in the Microsoft Teched (Israel) on the SQL Server track. I am also an active member of the Israel SQL Server Group. Stay tuned Yours, Maria

  • SQL SERVER – Identifying guest User using Policy Based Management

    Updated: 2012-02-27 01:30:35
    If you are following my recent blog posts, you may have noticed that I’ve been writing a lot about Guest User in SQL Server. Here are all the blog posts which I have written on this subject: SQL SERVER – Disable Guest Account – Serious Security Issue SQL SERVER – Force Removing User from Database – [...]

  • SQL SERVER – Standards Support, Protocol, Data Portability – 3 Important SQL Server Documentations for Downloads

    Updated: 2012-02-26 01:30:40
    I have been working with SQL Server for more than 8 years now continuously and I like to read a lot. Some time I read easy things and sometime I read stuff which are not so easy.  Here are few recently released article which I referred and read. They are not easy read but indeed [...]

  • SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS

    Updated: 2012-02-25 01:30:11
    “I do not know where my windows went!” “I just closed my object explorer and now I cannot find it.” “How do I get my original windows layout back in SQL Server Management Studio?” “How do I get the window which was there in left side back again?” Since last 2-3 years, every single day [...]

  • StreamInsight in Windows Azure: Austin February CTP

    Updated: 2012-02-24 03:39:17
    : THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in StreamInsight Team Entire Site Search Home Blogs Forums Downloads Opml StreamInsight Team StreamInsight in Windows Azure : Austin February CTP A few days ago , we updated the CTP Community Technology Preview of Project Codename Austin , the Windows Azure service that provides StreamInsight-based event processing in the Cloud . Apart from the service itself , we also updated the client bits and the . sample The new features in this version are : Service and query level restart upon Azure node reboot Monitoring of Austin instances , automatic restart of unresponsive instances Built-in HTTP-based ingress endpoint StreamInsight v1.2 feature parity : LINQ improvements , UDSO

  • SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database

    Updated: 2012-02-24 01:30:55
    I have written a few articles recently on the subject of guest account. Here’s a quick list of these articles: SQL SERVER – Disable Guest Account – Serious Security Issue SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in. SQL SERVER – Detecting [...]

  • Two new cumulative updates for SQL Server 2008 R2 are available!

    Updated: 2012-02-23 15:23:00
    Last night Microsoft released two new cumulative updates for SQL Server 2008 R2: Cumulative Update 5 for SQL Server 2008 R2 SP1 KB #2659694 Build 10.50.2806 16 fixes, including a nasty SCOPE_IDENTITY() bug and several performance fixes. My recommendation: You should test and plan for this update if SELECT @@VERSION is between 10.50.2500 and 10.50.2805. Cumulative Update 12 for SQL Server 2008 R2 (RTM) KB #2659692 Build 10.50.1810 3 fixes but none are directly related to the relational engine. My...(read more)

  • SQL Server 2012 at DevWeek London at the end of March

    Updated: 2012-02-23 05:23:00
    Hope that you'll find time in your schedule to ttend DevWeek 2012 in London, March 26-30. I'll be doing a preconference talk, an entire day of SQL Server 2012 for Developers. In addition, I present some breakouts on SQL Server security best practices, Extended Events and the new profiler, Mission-critical SQLCLR and other relevent topics. Here's hoping to see you there, drop by and say hi! @bobbeauch

  • Automate MDX Query Testing

    Updated: 2012-02-23 04:25:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Stacia Misner Entire Site Search Home Blogs Forums Downloads Opml Stacia Misner Automate MDX Query Testing In one my recent MDX classes , a student asked about automation of MDX queries for the purposes of testing query performance , so today I’ll answer that question and draw your attention to a few resources . available Get the ASCMD Utility If you’re running SQL Server 2008 Analysis Services or SQL Server 2008 R2 Analysis Services , you can download the ASCMD_StressTestingScripts from the Analysis Services Samples page on Codeplex to get the main prize , the compiled ASCMD executable . This version should also work with SQL Server 2005 Analysis Services , but I haven’t

  • SQL SERVER – Detecting guest User Permissions – guest User Access Status

    Updated: 2012-02-23 01:30:19
    Earlier I wrote the blog post SQL SERVER – Disable Guest Account – Serious Security Issue, and I got many comments asking questions related to the guest user. Here are the comments of Manoj: 1) How do we know if the uest user is enabled or disabled? 2) What is the default for guest user in SQL Server? [...]

  • Variable enhancements in RC0 [SSIS]

    Updated: 2012-02-22 22:56:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SSIS Junkie Entire Site Search Home Blogs Forums Downloads Opml SSIS Junkie Freelance SQL Server developer in London Variable enhancements in RC0 SSIS I have been poking around idly in the RC0 release of SQL Server Integration Services SSIS 2012 and noticed a few nice enhancements that hadn’t really hit the newsstands as yet well , I didn’t know about them anyway Here is a quick : rundown Expression is viewable in the Variables window Fairly self-explanatory this one . If a variable has an expression applied to it that expression can now be seen in the Variables window also notice that the variable icon gets an adorner specifying that there is an expression upon it . What is

  • Is the SSIS Catalog going to be enough?

    Updated: 2012-02-22 09:00:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SSIS Junkie Entire Site Search Home Blogs Forums Downloads Opml SSIS Junkie Freelance SQL Server developer in London Is the SSIS Catalog going to be enough Over the past year or so I have written at length about the SSIS Catalog that will be provided in the upcoming version of SQL Server Integration Services SSIS 2012 and the capabilities that it will bring one of the biggest benefits in my opinion is that logging is now something that is taken care of on your behalf . Many SSIS developers have built their own logging solutions often referred to as frameworks over the past few years and it occurred to me that many of those developers may have a need to carry on running their

  • A Few Thoughts on the SQL Server MCM Program

    Updated: 2012-02-22 07:11:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Argenis Fernandez Entire Site Search Home Blogs Forums Downloads Opml Argenis Fernandez A Few Thoughts on the SQL Server MCM Program I took the MCM lab a couple of weeks ago and passed . I still don’t believe it it’s been quite the journey . There have been many decisive moments in my career one of those was back in 2010 when I decided I would work on obtaining the certification after Brent Ozar blogged rather extensively about his experience with the program . I progressively worked on aspects of SQL Server that were out of my comfort zone and that paid off . But simply put , I have the cert but still don’t consider myself a true Master . And I probably never . will I might

  • SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video

    Updated: 2012-02-22 01:30:36
    We got tremendous response to our very first video of SQL in Sixty Seconds #001 and SQL in Sixty Seconds #002. We talked about how to convert Subquery to CTE and Error and Reaction. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to [...]

  • How to Incrementally Process your #Tabular Model by Using Process Add in #ssas

    Updated: 2012-02-22 00:31:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SQLBI Marco Russo Entire Site Search Home Blogs Forums Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server How to Incrementally Process your Tabular Model by Using Process Add in ssas I recently wrote an article about how to implement a Process Add on a table in a Tabular model This is an area where there is a lack of documentation by Microsoft , especially if you want to use a custom binding query for every Process Add command , which should be the common case for a Process Add scenario . Cathy Dumas wrote several blog posts about this argument and I tried to put everything together , showing the same example

  • Looking for Speakers at #PASS DW/BI Virtual Chapter

    Updated: 2012-02-21 13:24:34
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SQLBI Marco Russo Entire Site Search Home Blogs Forums Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server Looking for Speakers at PASS DW BI Virtual Chapter I recently joined Chris Webb Jen Stirrup and Alberto Ferrari as PASS Data Warehouse and Business Intelligence Virtual Chapter for Europe . We will increase the number of virtual sessions delivered in a comfortable European time zone and we are looking for speakers interested in sharing their knowledge in data warehouse and business intelligence with the Microsoft SQL Server . Platform If you are interested , please write to PASSDWBIVC sqlpass.org and

  • SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.

    Updated: 2012-02-21 01:30:42
    Yesterday I wrote a blog post discussing how guest user can become security threat. The script which was demonstrated for the example had a small T-SQL query which creates a new user. Later, I got an email from a user who had created this scenario on his production environment. It makes me sad that I [...]

  • The Road to Professional Database Development: Set-Based Thinking

    Updated: 2012-02-21 00:00:00
    Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets.

  • Big Data - A Microsoft Tools Approach

    Updated: 2012-02-20 21:16:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum Big Data A Microsoft Tools Approach As with all of these types of posts , check the date of the latest update I've made here . Anything older than 6 months is probably out of date , given the speed with which we release new features into Windows and SQL Azure I don't normally like to discuss things in terms of tools . I find that whenever you start with a given tool or even a tool stack it's too easy to fit the problem to the tool(s rather than the other way around as it should . be That being said , it's often useful to have an example to work through to better understand a concept . But

  • SQL SERVER – Disable Guest Account – Serious Security Issue

    Updated: 2012-02-20 01:30:26
    “No Guests PLEASE!” “Doesn’t your Indian tradition suggest welcoming guests and treating them in the best way possible?” “Yes, but I am talking about the Guest user in SQL Server.” “Oh!” This was a real conversation that happened a couple of years ago. I welcome guests as much as any other Indian does; however, I am strongly opinionated about [...]

  • Query Optimizer Gone Wild - Full-Text

    Updated: 2012-02-20 01:05:00
    Overall, SQL Server has become a very capable and mature product, with a very powerful engine and sophisticated query optimizer. Still, every now and then, a certain query structure throws the optimizer for a loop resulting in an execution plan that will take forever. The key to identifying this type of problem begins with the exeuction plan. First, the plan cost does not tell the whole story. It is necessary to know which execution plan operations can run well on modern server systems and which...(read more)

  • IDC WHITE PAPER - Microsoft SQL Server 2012: Potential Game Changer

    Updated: 2012-02-19 11:09:19
    : THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Davide Mauri Entire Site Search Home Blogs Forums Downloads Opml Davide Mauri A place for my thoughts and experiences on SQL Server , Business Intelligence and NET IDC WHITE PAPER Microsoft SQL Server 2012 : Potential Game Changer I think I can say that we all agree that SQL Server 2012 brings with revolution in our database world , since the number of new feature and new possibilities , IMHO , is comparable to what SQL Server 2005 brought several years . ago Interesting enough , even the well-known  IDC firm thinks that SQL Server 2012 can be a game changer . From a technical point of view the highlighted technologies : are AlwaysOn ColumnStore Index Windows Server Core

  • SQL SERVER – Migration Assistant for Oracle, MySQL, Sybase and Access v5.2

    Updated: 2012-02-19 01:30:43
    Migration is always the challenge, it does not matter if people are migrating from one country to another country or birds are migrating from one continent to another continent or database is migrating from one platform to another platform. I remember years ago when I had to migrate our database from another platform to SQL Server, [...]

  • Handle Duration Results from EnumHistory in PowerShell

    Updated: 2012-02-18 01:50:00
    Lately I've been very busy with client work, and one of my projects is to capture the history for SQL Agent jobs across all their servers so they can evaluate when to schedule jobs. (Yes, I know SQL Sentry has an excellent product for this, but right now there are budget constraints.) Anyway, I can do this in PowerShell with SMO. Once you connect to a server in SMO, the JobServer object has a collection called Jobs. For each job in that collection, you can call the EnumHistory method and it will...(<a href="http://sqlblog.com/blogs/allen_white/archive/2012/02/17/handle-duration-results-from-enumhistory-in-powershell.aspx"read more)

  • SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.

    Updated: 2012-02-18 01:30:35
    Jeff asked me another question! If you do not know Jeff, you may read the following blog posts. You will get the idea of Jeff’s personality and who Jeff really is. SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2 SQL SERVER – INNER JOIN Returning More Records than Exists in [...]

  • Issues with the system_health session in SQL Server 2012

    Updated: 2012-02-17 23:37:03
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Extended Events Entire Site Search Home Blogs Forums Downloads Opml Extended Events Issues with the system_health session in SQL Server 2012 The ever alert Jonathan Kehayias Blog Twitter sent me a question recently asking about the Extended Event UI used for showing predicates . In particular , he was wondering about the predicate for the wait_info event that is defined in the system_health session and was wondering what was going . on It’s obvious what peaked Jonathan’s interest all those error icons seem like there is a problem with the predicate . This post will explain what’s happening , why it’s happening and also document a problem that I discovered while investigating

  • SQL SERVER – Solution Part 2 – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

    Updated: 2012-02-17 01:30:44
    Some questions are timeless and they never grow old; no matter how much they grow old their interest never dies. Earlier, I asked a simple puzzle based on a conversation on SQLAuthority Page, and have received an overwhelming response from readers. I still get emails related to this puzzle every day. Before we move on, I suggest you [...]

  • Busy months ahead

    Updated: 2012-02-16 19:48:01
    Almost two months have passed since my last blog post. And while it’s true that I’ve had (much) longer breaks, I do have a good reason now. All the time that I would normally at least in part spend on preparing new blog posts is now reserved for preparing presentations for a few upcoming events. I’ll give you an overview – who knows, maybe you’ll have a chance to attend one of them and meet me there? I’m looking forward to it! On Saturday, February 25, I’ll present my session on “Advanced Indexing”...(read more)

  • SQL SERVER – Be Different – Be Leader – An Interactive Journey – Questions and Answers – Book and Video

    Updated: 2012-02-16 01:30:05
    This is a true story. My wife and my daughter were playing in the play area in our resident complex. I was sitting a ways off and was watching them play various games. My daughter likes the slides a lot. Suddenly, one kid started to climb the slide from the slide instead of the stairs. [...]

  • Exploring SSIS Architecture and Execution History Through Scripting

    Updated: 2012-02-16 00:00:00
    When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in TSQL as Feodor explains.

  • For Devs - Component Code Challenge and INETA Community Champs

    Updated: 2012-02-15 14:25:00
    Two quick notes from our friends over at INETA : Component Code Challenge Ever had these two distinct thoughts - "I have a good idea for an application, however what can I get for it?" and "I would love to go to a big conference DevConnections or Tech·Ed, but how would I pay for it?". Haven't we all had thoughts like that at some time or another? Well, you are in luck. The INETA Component Code Challenge for 2012 will send one lucky winner to their choice of those aforementioned conferences for slinging...(read more)

  • SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video

    Updated: 2012-02-15 01:30:11
    We got tremendous response to our very first video of SQL in Sixty Seconds #001. We talked about how to convert Subquery to CTE very quickly. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to readers. In today’s SQL in Sixty [...]

  • Co-Presenting A Day of SSIS with Matt Masson at SQL Saturday #111 in Atlanta 13 Apr 2012!

    Updated: 2012-02-15 00:00:00
    I am excited to co-present A Day of SSIS at the Atlanta SQL Saturday #111 13 Apr 2012! The SQL Saturday event will be Saturday 14 Apr 2012, but the precons (there are three!) will be Friday 13 Apr 2012. Matt Masson ( Blog | @mattmasson ) is co-presenting. If you have never had the opportunity to listen to Matt talk about SSIS, you should. Matt is one of the good people at Microsoft who develops and maintains SSIS. I hope to see you there. Register here ! :{>...(read more)

  • SQL SERVER – What is Big Data – An Explanation in Simple Words

    Updated: 2012-02-14 01:30:55
    Decoding the human genome originally took 10 years to process; now it can be achieved in one week - The Economist. This blog post is written in response to the T-SQL Tuesday post of The Big Data. This is a very interesting subject. Data is growing every single day. I remember my first computer which had [...]

  • SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar

    Updated: 2012-02-13 01:30:54
    “I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.” I often get questions from people who are new to technology and struggling to get something done. However, this time it was not a question from any beginner. [...]

  • SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

    Updated: 2012-02-12 01:30:11
    I am in front of computer 16+ hours of the day. However, I accept that I am bit lazy when it is about doing installation etc. I always prefer that IT department help me to install my computer and I use it right away. Same feeling I get when I have to install Beta, RC [...]

  • New T-SQL 2012 scalar functions (all but 1) work in SQL Azure

    Updated: 2012-02-11 23:44:00
    Home Syndication Log in New T-SQL 2012 scalar functions all but 1 work in SQL Azure Back when I was saw SQL Azure was producing an version string that mentioned version 11 that's SQL Server 2012's major version number I'd started looking at the version number every week or so . And looking for SQL Server 2012 functionality in SQL Azure . See the blog post SQL Denali T-SQL features in SQL Azure now for a list of the first functions supported . I'm not going to list them all again here . And Ed Katibah's a.k.a Spatial Ed latest list of SQL Server 2012 spatial functionality in SQL Azure This week , I'd thought to look at the SQL Azure version again . I get : Microsoft SQL Azure RTM 11.0.1831.30 Jan 27 2012 23:11:55 Copyright c Microsoft Corporation This is different newer than when I

  • SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

    Updated: 2012-02-11 01:30:19
    Yesterday was really fun. I asked a simple Brain Teaser and we had excellent conversation on SQLAuthority Page as well SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser. That was an easy puzzle for those who have attended the SQL Server Questions and Answers online course. Here is a quick recap of the puzzle. Lots [...]

  • SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

    Updated: 2012-02-10 01:30:26
    It seems that we all love to solve puzzles. On SQLAuthority Page, we have been playing the number game and those who are playing with us know how much fun we are having. Sometimes, the answers are so innovative and informative that they open up those aspects of the technology which I have not thought [...]

  • SQL SERVER – INNER JOIN Returning More Records than Exists in Table

    Updated: 2012-02-09 01:30:29
    I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was. He was very happy when I featured his story [...]

  • SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

    Updated: 2012-02-08 01:30:58
    SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to [...]

  • SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2

    Updated: 2012-02-07 01:30:41
    Here is email received from user: “Pinal, I am new DBA in my organization and I have to manage SQL Server 2005, 2008 and 2008 R2. Today is my first day at job and my manager has asked me to install all these different edition on our test environment. I have finished installing them. Later [...]

  • SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner

    Updated: 2012-02-06 01:30:16
    Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the whole database. As the database was very big he dropped it in common location (you can use livemesh [...]

  • SQLAuthority News – Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

    Updated: 2012-02-05 01:30:33
    SQL Server 2012 is has very exciting new feature of SQL Server AlwaysOn. This new feature reduces planned and unplanned downtime and maximize application available. Additionally it provides data protection keeping database always available. Microsoft has released a whitepaper on this subject where it discusses common context business stakeholders, technical decision makers, system architects, infrastructure [...]

  • Automated Script-generation with Powershell and SMO

    Updated: 2012-02-03 00:00:00
    In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases, Phil Factor demonstrates how one can generate TSQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.

  • Using SQL Test Database Unit Testing with TeamCity Continuous Integration

    Updated: 2012-02-02 00:00:00
    With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles, but how, exactly? Dave Green describes a successful process that integrates third-party tools.

Current Feed Items | Previous Months Items

Jan 2012 | Dec 2011