Search Results

Search found 28900 results on 1156 pages for 'sql 2005'.

Page 136/1156 | < Previous Page | 132 133 134 135 136 137 138 139 140 141 142 143  | Next Page >

• Can not access SQLServer database

  - by btrey

  I'm trying to convert an Access database to use a SQLServer backend. I've upsized the database and everything works on the server, but I'm unable to access it remotely. I'm running SQLServer Express 2005 on Windows Server 2003. The server is not configured as a domain controller, nor connected to a domain. The computers I'm trying to access the…

  Read the article

• SQL Server 2008 T-SQL Enhancements Part - II

  Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.

  Read the article

• My first SQL Saturday

  - by Paul Nielsen

  I’m leaving soon for an exciting journey with a thrilling destination – my first SQL Saturday. So I decided to do it right and I’m taking the Amtrak Acela Express from Boston to New York. I love New York! If you’re headed to SQL Saturday #39, and you love database design, I invite you to come to my session on Temporal Database Designs – how to…

  Read the article

• T-SQL Tuesday #005: Reporting

  - by Adam Machanic

  This month's T-SQL Tuesday is hosted by Aaron Nelson of SQLVariations . Aaron has picked a really fantastic topic: Reporting . Reporting is a lot more than just SSRS. Whether or not you realize it, you deal with all sorts of reports every day. Server up-time reports. Application activity reports. And even DMVs, which as Aaron points out are…

  Read the article

• Open the SQL Server Error Log with PowerShell

  - by BuckWoody

  Using the Server Management Objects (SMO) library, you don’t even need to have the SQL Server 2008 PowerShell Provider to read the SQL Server Error Logs – in fact, you can use regular old everyday PowerShell. Keep in mind you will need the SMO libraries – which can be installed separately or by installing the Client Tools from the SQL…

  Read the article

• New licensing for SQL Server 2012 and #BISM #Tabular usage

  - by Marco Russo (SQLBI)

  Last week Microsoft announced a new licensing schema for SQL Server 2012. If you are interested in an extensive discussion of the new licensing scheme, Denny Cherry wrote a great blog post about that. I’d like to comment about the new BI Edition license. Teo Lachev already commented about the numbers and I agree with him. I generally…

  Read the article

• T-SQL Tuesday #4: I/O, You Know

  - by Kalen Delaney

  It's time for the fourth T-SQL Tuesday , managed this time by Mike Walsh . I almost missed this deadline completely, since I didn't see the announcement at all. I wrote to Adam to ask if there even was an event this month, since I wasn't able to get into my own blog site ( www.SQLBlog.com ) for a week, and he pointed me to Mike's…

  Read the article

• Open the SQL Server Error Log with PowerShell

  - by BuckWoody

  Using the Server Management Objects (SMO) library, you don’t even need to have the SQL Server 2008 PowerShell Provider to read the SQL Server Error Logs – in fact, you can use regular old everyday PowerShell. Keep in mind you will need the SMO libraries – which can be installed separately or by installing the Client Tools from…

  Read the article

• SQL Trace challenge: a simple requirement

  - by Linchi Shea

  SQL Trace (or SQL Profiler) is no doubt an excellent tool. But its filtering capability is rather primitive, and is very poorly documented. Here is a request that is simple and seems to be rather reasonable. Create a trace to filter for the following: 1. All the update/delete statements, and 2. All the select/insert statements…

  Read the article

• New SSIS features and enhancements in Denali – a webinar on 28th June in association with Pragmatic Works

  - by jamiet

  Tomorrow I shall be presenting a webinar entitled “New SSIS features and enhancements in Denali”. The webinar is being hosted by Pragmatic Works and you can sign up for it at Pragmatic Works webinars. The webinar will start at 1930BST and you can view the time for your timezone at this link:…

  Read the article

• SQL Saturday #39 in NYC

  - by roman

  This weekend I will be speaking at the NYC SQL Saturday . The whole event was supposed to be BI focused but now the schedule shows a lot of non BI stuff as well. I will be presenting SQL Server 2008 Reporting Services Programming , one of my favorite topics to present on. It seems that the…

  Read the article

• SQL Azure and Trust Services

  - by BuckWoody

  Microsoft is working on a new Windows Azure service called “Trust Services”. Trust Services takes a certificate you upload and uses it to encrypt and decrypt sensitive data in the cloud. Of course, like any security service, there’s a bit more to it than that. I’ll give you a quick…

  Read the article

• Using SQL Profiler to Resolve Deadlocks in SQL Server

  MVP Jonathan Kehayias brings us a short article on how to troubleshoot deadlocks in SQL Server.

  Read the article

• SQL Server Maintenance Utilities Update for SQL Server 2008 R2

  - by Greg Low

  Great to see that our friend Ola Hallengren has updated his maintenance utility scripts to deal with SQL Server 2008 R2. These scripts are highly regarded, particularly given the price: free ! You'll find them here: http://ola.hallengren.com/Versions.html Ola noted that the main…

  Read the article

• 5 Things SQL Server should get rid of

  - by Jonathan Kehayias

  Paul Randal ( blog | twitter ) started a new meme last night with his blog post " What 5 things should SQL Server get rid of? " A few bloggers have posted their top 5 lists, so here is mine. Creating Foreign Keys without mentioning Indexes This is probably a performance tuning…

  Read the article

• Using the @ in SQL Azure Connections

  - by BuckWoody

  The other day I was working with a client on an application they were changing to a hybrid architecture – some data on-premise and other data in SQL Azure and Windows Azure Blob storage. I had them make a couple of corrections - the first was that all communications to SQL…

  Read the article

• SQL Bits VII

  - by Tomaz.tsql

  I was very happy to dive in into SQL Bits VII. Several interesting presentations, interesting concepts, advices and most of all interesting people. Some things actually disturb me. 1. the outlook of all presentations. I would recommend to have standardized outlook of all…

  Read the article

• SQL Server Central launches online training for SQL Server Developers, DBA’s, and Analyst’s

  Build your SQL Server skills without leaving your desk.

  Read the article

• Will VS2010 work with Visual Source Safe 2005?

  - by DanH

  Until I can convince others to convert over to Team Foundation Server 2010 (TFS2010), I'm still going to use Visual Source Safe 2005 (VSS2005). I will be upgrade to Visual Studio 2010 (VS2010) soon. What do I need to get VS2010 to work with VSS2005? I understand there…

  Read the article

• SQL Monitor’s data repository

  - by Chris Lambrou

  As one of the developers of SQL Monitor, I often get requests passed on by our support people from customers who are looking to dip into SQL Monitor’s own data repository, in order to pull out bits of information that they’re interested in. Since there’s clearly…

  Read the article

• Force "2005" for ProviderManifestToken in EF Data Model.

  - by ProfK

  Every time I update my data model, it makes this value 2008, breaking the 2005 server deployment. Is their anything besides a build action I can use to stop this?

  Read the article

• A pseudo-listener for AlwaysOn Availability Groups for SQL Server virtual machines running in Azure

  - by MikeD

  I am involved in a project that is implementing SharePoint 2013 on virtual machines hosted in Azure. The back end data tier consists of two Azure VMs running SQL Server 2012, with the SharePoint databases contained in an AlwaysOn Availability Group. I used…

  Read the article

• How to find 3rd max value of a column using MAX function in sql server?

  - by Pandiya Chendur

  Yesterday i had a question in an interview which i thought i could find answers here in SO... How to find 3rd max value of a column using MAX function in sql server? Consider the column to be Wages 20000 15000 10000 45000 50000

  Read the article

• VS2010 Using SQL Server 2000

  - by Chris M

  Is there a way to use the SQL Model (dbml) builder in VS2010 using SQLServer2000? It works fine in VSExpress2008 + VS2008 but throws an "Upgrade SQL to 2005" error in VS2010 which seems a tad unreasonable.

  Read the article

• Convert SQLExpress 2005 .mdf to 2008 .mdf ?

  - by Pricey

  Hi I have a Visual Studio solution and an ASP.NET MVC project that uses an mdf sql express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for sql express 2008 ? Thanks

  Read the article

< Previous Page | 132 133 134 135 136 137 138 139 140 141 142 143  | Next Page >