How can I disable the windows authentication mode of SQl Server
- by Azhar
How can I disable the windows authentication mode of SQl Server and restrict it to ask for user and Password every time and no windows authentication. for security purposes
Search Results
Search found 28297 results on 1132 pages for 'sql azure'.
Page 48/1132 | < Previous Page | 44 45 46 47 48 49 50 51 52 53 54 55 | Next Page >
-
-
Migrating SQL server 2000 database to SQL server 2005
- by rboorgapally
Can any one suggest variou ways of migrating a database from SQL server 2000 to 2005. How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that preserves them.Read the article
-
Sql Server Managmenet Studio Alternative - Are there any?
- by JohnM2
I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's great for learning Linq). It can only query database (and has many cons for my needs). I am looking for management/alteration functionality also, not…Read the article
-
An XEvent a Day (11 of 31) – Targets Week – Using Multiple Targets to Debug Orphaned Transactions
- by Jonathan Kehayias
Yesterday’s blog post Targets Week – etw_classic_sync_target covered the ETW integration that is built into Extended Events and how the etw_classic_sync_target can be used in conjunction with other ETW traces to provide troubleshooting at a level previously not possible with SQL Server. In today’s post we’ll look at how to use multiple targets…Read the article
-
An XEvent a Day (18 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2)
- by Jonathan Kehayias
In yesterday’s blog post A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1) , we looked at what happens when we Backup a database in SQL Server. Today, we are going to use the information we captured to perform some analysis of the Backup information in an attempt to find ways to decrease the time it takes…Read the article
-
SQL Server 2005 SP4 is here!
- by AaronBertrand
Yes, the day has finally arrived, and a couple of weeks ahead of schedule. Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day of that quarter or half. This year, we get an early Christmas present: SQL Server 2005 SP4. To download SP4, go to this link:…Read the article
-
An XEvent a Day (3 of 31) – Managing Event Sessions
- by Jonathan Kehayias
Yesterdays post, Querying the Extended Events Metadata , showed how to discover the objects available for use in Extended Events. In todays post, we’ll take a look at the DDL Commands that are used to create and manage Event Sessions based on the objects available in the system. Like other…Read the article
-
An XEvent a Day (15 of 31) – Tracking Ghost Cleanup
- by Jonathan Kehayias
If you don’t know anything about Ghost Cleanup, I recommend highly that you go read Paul Randal’s blog posts Inside the Storage Engine: Ghost cleanup in depth , Ghost cleanup redux , and Turning off the ghost cleanup task for a performance gain . To my knowledge Paul’s posts are the only things…Read the article
-
An XEvent a Day (14 of 31) – A Closer Look at Predicates
- by Jonathan Kehayias
When working with SQL Trace, one of my biggest frustrations has been the limitations that exist in filtering. Using sp_trace_setfilter to establish the filter criteria is a non-trivial task, and it falls short of being able to deliver complex filtering that is sometimes needed to simplify…Read the article
-
An XEvent a Day (16 of 31) – How Many Checkpoints are Issued During a Full Backup?
- by Jonathan Kehayias
This wasn’t my intended blog post for today, but last night a question came across #SQLHelp on Twitter from Varun ( Twitter ). #sqlhelp how many checkpoints are issued during a full backup? The question was answered by Robert Davis (Blog|Twitter) as: Just 1, at the very start. RT @ 1sql :…Read the article
-
An XEvent a Day (2 of 31) – Querying the Extended Events Metadata
- by Jonathan Kehayias
In yesterdays post, An Overview of Extended Events , I provided some of the necessary background for Extended Events that you need to understand to begin working with Extended Events in SQL Server. After receiving some feedback by email (thanks Aaron I appreciate it), I have changed the…Read the article
-
Backup Meta-Data
- by BuckWoody
I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and…Read the article
-
Backup Meta-Data
- by BuckWoody
I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and…Read the article
-
Finalists for the Microsoft Accelerator for Windows Azure
- by ScottGu
Today, I am pleased to announce the ten finalists for the Microsoft Accelerator for Windows Azure powered by TechStars. These startups are about to launch into a three-month program where they will develop new products and businesses using Windows Azure. The response to the…Read the article
-
On the Fourth Day of the SQL Series...
- by andyleonard
Introduction Brent Ozar ( Blog | @BrentO ) has done it again - started something. This time it's The Twelve Days of SQL Series . I was passed the baton from David Stein ( Blog | @made2mentor ) who covered Day 3 with a tribute to his favorite post . And Now, My Selection: I…Read the article
-
SQL Server 2008 R2 Feature Pack, get yours now
- by ssqa.net
In continuation to the SQL Server 2008 R2 RTM release here is the another download the Feature Pack which consist the a collection of stand-alone packages which provide additional value to your R2 environment.... more here .......(read more)Read the article
-
SQL Server v.Next (Denali) : OS compatibility & upgrade support
- by AaronBertrand
Microsoft's Manageability PPM Dan Jones has asked for our feedback on their proposed list of supported operating systems and upgrade paths for the next version of SQL Server. (See the original post ). This has generated all kinds of spirited debates on twitter, in…Read the article
-
RedGate SQL Source Control and TFSPreview
- by andyleonard
I am excited that RedGate ’s SQL Source Control now supports connectivity to TFSPreview , Microsoft ’s cloud-based Application Life Cycle Management portal. Buck Woody ( Blog | @buckwoody ) and I have written about TFSPreview at SQLBlog already: Team…Read the article
-
An XEvent a Day (23 of 31) – How it Works – Multiple Transaction Log Files
- by Jonathan Kehayias
While working on yesterday’s blog post The Future – fn_dblog() No More? Tracking Transaction Log Activity in Denali I did a quick Google search to find a specific blog post by Paul Randal to use it as a reference, and in the results returned another blog…Read the article
-
Enabling super single user mode with SQL Server
- by simonsabin
I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more…Read the article
-
SQL Solstice
- by andyleonard
Introduction My friends in North Carolina have decided to create a new event called SQL Solstice . Details: 18 - 20 Aug 2011 Holiday Inn Brownstone & Conference Center 1707 Hillsborough Street - Raleigh, NC 27605 Toll Free 800-331-7919 18 Aug - A…Read the article
-
Windows Azure Diagnostics: Next to Useless?
- by Your DisplayName here!
To quote my good friend Christian: “Tracing is probably one of the most discussed topics in the Windows Azure world. Not because it is freaking cool – but because it can be very tedious and partly massively counter-intuitive.” <rant> …Read the article
-
SQLSaturday #69 - Philly Love
- by Mike C
Thanks to the Philly SQL Server User Group (PSSUG) and to everyone who attended SQLSaturday #69 in the City of Brotherly Love yesterday. It was a great event with a lot of great people. My presentations are available for download at the links below:…Read the article
-
Spatial data from shapefiles (for T-SQL Tuesday #006)
- by Rob Farley
I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data, and in particular, the visualization of said data. Given that it’s about one the larger types, this post should also count towards Michael…Read the article
-
SQL Server 2008 Table Maintenance - Rebuild, Reorganize, Update Stats, Check Integrity etc HELP!
- by Albert
I'm migrating a ~15GB database from SQL Server 2005 to a new server running SQL Server 2008, and along with that I need to create all the new Maintenance Plans. I can take care of all the backup stuff, but the table maintenance baffles me…Read the article
