sqlmag.com

Please wait for loading...




      (2986):

    /
     1  ~ 2014 sep 22games pad database forum sqlForums - SQL Server ProAsk and get answers to your SQL Server database design and development ... Gizmos, gadgets, toys and games - here's a place for you to post about what ...
     1  ~ 2014 sep 05xfusion studio costSimplify Your Data Migration and Integration Process with xFusion Software Labs' xFusion Studio 4.0 is now available and includes SQL ... to cut costs , consolidate data, and streamline business processes.
     1  +1 2014 aug 24sql server knowledge baseSQL Server Knowledge Base Articles - SQL Server MagazineSenior technical editor Michael Otey highlights seven recent Knowledge Base articles about SQL Server .
     1  +9 2014 aug 24sql server ssdUsing Solid State Disks in SQL Server Storage Solutions | Storage Microsoft SQL Server machines require you to change the way you think about ... As long as the amount of SSD storage is a little larger than the ...
     1  ~ 2014 aug 24pro sql securityDatabase Security | SQL Server ProMicrosoft SQL Server security best practices, information, and solutions for database administrators. Tips on authentication, encryption, permissions, and more.
     1  ~ 2014 aug 12sql server magazineSQL Server Pro | Microsoft SQL Server Database Administration News and technical articles about SQL Server . By Penton Media, Inc. SQL Server Magazine Goes
     1  +3 2014 jul 31sql server performance slowTroubleshooting Slow Servers - SQL Server ProMissing indexes, an inadequate storage I/O subsystem, or a slow network ... When troubleshooting a performance problem within a SQL Server  ...
     1  +3 2014 jul 28data warehouse projectSeven Steps for Successful Data Warehouse Projects | Database A data warehouse project has three tracks—the data track, the technology track, and the application layer track, as illustrated in Figure 1.
     1  +2 2014 jul 26best free sql tool2013 Best Free Tool | SQL Server content from SQL Server ProOla Hallengren's SQL Server Maintenance Solution wins the 2013 SQL Server Pro Community Choice Award for Best Free Tool .
     2  ~ 2014 oct 04access to sql15 Steps to Convert Access Data to SQL Server | Database Here is one consultant's experience with converting small to mid-sized Access JET projects to SQL Server 6.x.
     2  ~ 2014 sep 30sql server log filesSQL Server Log Files Update | Database Administration content To fix SQL Server problems, it's crucial to know as much as possible about the issue. Here are the best places to find log files for ...
     2  +26 2014 sep 17import big sql dataAdventures with Big Data : How to Import 16 Billion ... - SQL Server ProIf you have a lot of data to import into or export out of a SQL Server table, here are some tips that can save you a lot of time and aggravation.
     2  +1 2014 sep 11sql azure free trial3 Month Free Trial of SQL Azure | SQL SELECT Blog - SQL Server ProIf you've been interested in giving SQL Azure a try but have been put off by the price then you may want to check Microsoft's 3 month trial of ...
     2  +5 2014 sep 02defrag ms sqlShould I Defragment My SQL Server Data Files? | Database A I'm not sure that Microsoft has an "official" defragmentation recommendation for SQL Server data files, but I believe that OS-level defragmentation can often ...
     2  +3 2014 aug 30log explorer sql serverLog Explorer 3.03 | SQL Server content from SQL Server ProLumigent Technologies has released a new version of Log Explorer , one of the best-selling third-party products in the SQL Server space. Log Explorer reads a ...
     2  +2 2014 aug 27sql server log explorer
     2  +2 2014 aug 25graphical view sql profilerGathering Deadlock Information with Deadlock Graph - SQL Server As Figure 3 shows, graphical rendering in SQL Server Profiler or SSMS provides an intuitive view of the most important information in the file at ...
     2  +1 2014 aug 23sql server database engineSQL Server Database Engine Basics - SQL Server MagazineAlthough the SQL Server database engine is the core service for processing data , it's often misunderstood. However, knowing how the ...
     2  +2 2014 aug 22convert access to sqlserver
     2  +5 2014 aug 19access to sql server
     2  +10 2014 aug 15database design software comparisonComparative Review : Sizing Up Data Modeling SoftwareFind out how six popular data modeling software packages stack up to ... Ability to compare database models at the physical level to map the ...
     2  +2 2014 aug 15virtual database serverRunning SQL Server in a Virtual Server Environment | Database Running SQL Server on a physical server means that the server doesn't need to compete with other virtual servers for resources, and a ...
     2  +2 2014 aug 14convert access to sql
     2  ~ 2014 aug 12what is msdeSQL Server/Office Integration: What Is MSDE ? | Database The Microsoft Data Engine ( MSDE ) makes SQL Server technology available in development contexts that were previously restricted to the Jet database engine.
     2  +2 2014 aug 08sql server system tablesSystem Tables - SQL Server MagazineSQL Server maintains a set of tables of information about objects, data types, constraints, configuration options, and resources available to the SQL Server  ...
     2  +5 2014 aug 07sql server coalesceCOALESCE vs. ISNULL - SQL Server MagazineThe COALESCE and ISNULL T-SQL functions are used to return the first nonnull expression among the input arguments. SQL Server  ...
     2  +99 2014 aug 06user database administration conclusionThe DBA is Alive and Well—Here's Why - SQL Server MagazineAs a database administrator ( DBA ), should you be worried about the
     2  +3 2014 aug 05sql server database inventoryBuilding a SQL Server Inventory Report | Reporting content from A SQL Server inventory stores information about the SQL Server instances in ... A majority of these servers are desktop SQL Server database  ...
     2  +3 2014 aug 03ms sql encryptionSQL Server Encryption Options | Database Security content from SQL Server 2012 can encrypt data--and has many different ... about BitLocker at the Microsoft article, "BitLocker Driver Encryption Overview.".
     2  +1 2014 aug 02encryption in sql serverSQL Server 2012 can encrypt data--and has many different encryption capabilities. Let us guide you through which ones to use.
     2  +7 2014 aug 01sql server on ssdWith the cost of solid state disks ( SSDs ) going down, many ... the way you think about designing storage for production SQL Server servers.
     2  +3 2014 jul 24sql full text searchSample Full - Text Search Engine - SQL Server MagazineIn the following example, I'll create a simple SQL Server table and a full - text search engine to run against it. Related: Build a Better Search Engine and ...
     2  +93 2014 jul 21sql engine queryThe storage engine writes data to and retrieves data from stable media (e.g., disks). The query processor accepts, parses, and executes SQL  ...
     2  +6 2014 jul 19visual database toolVisual Studio 2010 Database Tools - SQL Server MagazineFind database tools for SQL Server developers in Visual Studio 2010? Yes, and they could make your database application development ...
     3  -1 2014 oct 05sql server logs
     3  -1 2014 oct 03schedul indexing at nightIs It a Bad Idea to Rebuild All Indexes Every Night ... - SQL Server ProQ: Our index maintenance plan is about as simple as it gets: We rebuild all of our indexes every night . The problem is that it's taking longer and ...
     3  +38 2014 sep 27mssql portSQL Server TCP and UDP Ports - SQL Server MagazineTired of trying to figure out which TCP and UDP ports SQL Server uses? This quick reference points you in the right direction.
     3  ~ 2014 sep 27sql server log fileSQL Server Log Files Update - SQL Server Magazine
     3  -1 2014 sep 27sql log file
     3  ~ 2014 sep 25sqlserverNews and technical articles about SQL Server . By Penton Media, Inc.
     3  ~ 2014 sep 23sql server
     3  +5 2014 sep 21sql portSQL Server TCP and UDP Ports | SQL Server content from SQL
     3  +79 2014 sep 18linqpad reporting engineLINQPad | Database Development content from SQL Server ProThis free LINQPad tool lets you interactively query SQL Server using LINQ.
     3  +46 2014 sep 12sp executesql new lineWeb Listing 1@ newline AS NVARCHAR(2), @msg AS NVARCHAR(500); SET @ newline ... + @cols + N')' + @ newline + N' ) AS PivotOutput;'; EXEC sp_executesql @sql; ...
     3  -1 2014 sep 03function dofscommand decryptionSimple String Encryption and Decryption | T-SQL content from SQL Encrypt and dbo. Decrypt . The dbo. Encrypt function encrypts the plaintext that you pass to it, whereas the dbo. Decrypt function decrypts the ...
     3  +4 2014 sep 02sql server password encryptionSQL Server's Undocumented Password Encryption Functions | SQL You can use the same techniques to build your own password encryption tools in SQL Server 2000. A short piece of sample code for SQL Server 7.0 or 2000 at ...
     3  +4 2014 aug 29sql express editionSQL Server 2014 Express Editions - SQL Server MagazineLearn about the new SQL Server 2014 Express editions .
     3  +6 2014 aug 29lumigent log explorer
     3  +9 2014 aug 28sql excel proIs Excel the Next Killer BI App? | SQL Server BI BlogMicrosoft Excel was the spreadsheet killer app of the 90's, eliminating VisiCalc, Lotus 1-2-3, Quattro Pro , and many other players. According to ...
     3  +1 2014 aug 27data mining sql serverGetting Started with Data Mining in SQL ServerUse the Data Mining Model Designer in SQL Server Data Tools (SSDT) and the data mining add-ins for Excel 2013 to mine data in SQL Server .
     3  +25 2014 aug 24sql server biBusiness Intelligence | SQL Server ProBusiness intelligence information and tools for database administrators. Learn about PowerPivot, Power View, Report Builder, SSAS, SSIS, SSRS and more.
     3  ~ 2014 aug 20apex sql connection monitorApexSQL Log | SQL Server content from SQL Server ProOur review of ApexSQL Log will help you decide whether this app fits ... When running the connection monitor on SQL Server 2005 or 2000 ...
     3  +2 2014 aug 15virtual hosting mssqlRunning SQL Server in a Virtual Server Environment - SQL Server ProVirtual . Most SQL Server installations don't use 100 percent of a server's resources all the time. In fact, many SQL Server applications use only ...
     3  +1 2014 aug 13ms sql declare variableWorking with Variables in T- SQL , Part 1 | T- SQL content from SQL Before SQL Server 7.0, the only way to assign values to variables was to use an assignment SELECT statement. In SQL Server 7.0, Microsoft added the SET  ...
     3  +2 2014 aug 10distinct group byDISTINCT vs. GROUP BY | Database Performance Tuning content Should I use DISTINCT or GROUP BY to eliminate duplicates in a result set?
     3  +1 2014 aug 05sql server raiserrorAll About RAISERROR | T-SQL content from SQL Server ProBy using a special value for the RAISERROR state parameter, you can force the termination of a complex script and prevent its execution in the wrong database.
     3  ~ 2014 aug 04sql sentry pllan explorerFree Tool: SQL Sentry's Plan Explorer | Database Administration I recently had the chance to sit down with my friend and fellow SQL Server MVP Aaron Bertrand to review SQL Sentry's free tool Plan Explorer .
     3  +4 2014 aug 04visual studio database professionalsVisual Studio 2010 for Database Professionals ... - SQL Server ProAs a developer, you use Visual Studio (VS) to build many flavors of applications for the .NET Framework. Typically, a new release of VS comes ...
     3  +98 2014 aug 03how to post xmlSending XML Documents over HTTP | Database Development BizTalk can use several methods to accept an XML document. For my application , I send the XML document to an Active Server Pages (ASP) page that then ...
     3  ~ 2014 aug 03sql server connector oracleSQL Server and Oracle : Making the Connection ... - SQL Server ProLinking servers is fairly straightforward when they're all SQL Servers --but what happens when your company has data in both SQL Server and Oracle ? Here's a  ...
     3  +1 2014 aug 01disaster prevention stepsDisaster Prevention : Preparing for the Worst | Database Backup and Many people break the subject of high availability into two parts— disaster prevention and disaster recovery—and discuss the topic as if every step in a ...
     3  +19 2014 jul 30sql server developer editionSQL Server 2014 Developer Edition Licensing - SQL Server ProLearn whether or not the SQL Server 2014 Developer Edition is licensed per user and, if so, if it limited to a single user at a time.
     3  +14 2014 jul 27apex sql toolsDatabase Schema Comparison Tools - SQL Server MagazineThe author tests four tools for comparing database schemas: Red Gate Software's SQL Compare 9.0, ApexSQL's ApexSQL Diff, xSQL ...
     3  +2 2014 jul 26cloudberry backup server editionMy Favorite Tool of 2013: CloudBerry Backup - Server Edition Last year I blogged about Devolutions' Remote Desktop Manager—an exceptionally useful, valuable, and well-managed product that I decided ...
     3  ~ 2014 jul 24powershell script argumentsPassing SQL Server Command-Line Arguments to PowerShell You can write easy scripts in PowerShell to get things done quickly, but ... features of PowerShell command line arguments to help those who ...
     3  ~ 2014 jul 23sgl index tuning traceBoost Performance with the Index Tuning Wizard - SQL Server Next, you can create a trace in SQL Profiler for the ITW to analyze. ... Wizards from the tools menu, open Management, and select the Index Tuning Wizard).
     3  -1 2014 jul 22scalable shared databasesToo Cool! Scalable Shared Databases - SQL Server Magazinedescribes a extraordinary new feature called Scalable Shared Databases (SSD). SSDs are a feature of SQL Server Enterprise edition to access ...
     3  +4 2014 jul 18phoenix sql fixStellar Phoenix SQL recovery software - SQL Server Pro - Forums Stellar Phoenix SQL recovery software is now available to repair corrupt SQL server database files and objects. Stellar Phoenix SQL recovery ...
     4  +1 2014 oct 04sql server business intelligence
     4  -1 2014 oct 02mdb to sqlThe names in the . mdb file must comply with the rules for SQL Server 6.5 identifiers. If the table names or field names aren't valid SQL Server identifiers, the ...
     4  -2 2014 sep 30sql server log
     4  +1 2014 sep 25sql server if existsEXISTS vs. COUNT(*) | T-SQL content from SQL Server ProUsing an EXISTS check is more efficient than a SELECT COUNT(*) when you need to see if a particular value exists in a table.
     4  ~ 2014 sep 16sql server expressSQL Server 2014 Express Editions - SQL Server ProLike the earlier releases, all of the different SQL Server 2014 Express editions are completely free and they are completely capable of ...
     4  ~ 2014 sep 10bi dimensionData Warehousing: Dimension Basics | Business Intelligence Knowing the basics of SQL Server data warehousing and dimensions helps you design a better data warehouse that fits your reporting needs.
     4  ~ 2014 sep 06sql server express edition
     4  +97 2014 aug 30mssql web editionSQL Server 2012 Editions - SQL Server ProHere's a quick overview of the SQL Server 2012 family, including Enterprise, Business Intelligence, Standard, Web , Developer, and Express ...
     4  +73 2014 aug 29sql versions comparisonSQL Server 2012 Editions - SQL Server MagazineAs you would expect, Microsoft's new SQL Server 2012 release will include many new features , but perhaps most importantly, it will also mark ...
     4  +1 2014 aug 25sql server data mining
     4  +14 2014 aug 19change database collationA Seven-Step Process for Changing a Database's CollationWith SQL Server, you can easily change the collation of a database . Before you do so, though, you should be familiar with the purpose and ...
     4  +3 2014 aug 08sharepoint database optimizationSharePoint Performance Optimization with SQL Server | SharePoint Running SharePoint on a poorly designed SQL Server environment will slow ... your disk system for maximum performance at the database level.
     4  +1 2014 aug 02dimensions in bi
     4  +1 2014 aug 01sql maintenance utilityThe Mega Guide to Free SQL Server Tools | Database Performance SQL Server Automation Scripts—This tool provides SQL Server Agent jobs that you can use to perform automated maintenance tasks ...
     4  +6 2014 jul 24sql address standardizationWhy You Need Database Normalization - SQL Server MagazineOne item of data, such as a first name, a last name, a phone number, or a street address , appears in each box, or cell, at each intersection of a row and column.
     4  +24 2014 jul 22data discovery excelQuite a few data discovery and BI vendors advertise anti- Excel messaging in one way, shape, or form. Since Excel is where most analytic tasks ...
     4  +10 2014 jul 21sql server change collationChanging a Database's Collation - SQL Server MagazineWith SQL Server , you can easily change the collation of a database. Before you do so, though, you should be familiar with the purpose and ...
     4  +5 2014 jul 21multiple sql virtual serverEssential Tips for Virtualizing SQL Server - SQL Server MagazineVirtualizing SQL Server provides many benefits. ... They can be the difference between a poorly performing virtual SQL Server instance and a ...
     4  -1 2014 jul 19power pivot sql serverUnderstanding PowerPivot and Power View in Microsoft Excel 2013 Power View provides intuitive data visualization of PowerPivot models and SQL Server Analysis Services (SSAS) tabular mode databases.
     4  -2 2014 jul 19ms sql virtual serverTraditionally, SQL Servers run on dedicated hardware. ... With VMware's VMware Server and Microsoft Virtual Server 2005, you can allocate a ...
     4  +2 2014 jul 17data modeling softwareComparative Review: Sizing Up Data Modeling SoftwareFind out how six popular data modeling software packages stack up to each other.
     4  +18 2014 jul 17sql log shipping3 Log Shipping Techniques | Database High ... - SQL Server ProAlthough log shipping isn't as widely used as it once was, it's still a vital tool that has many applications. Here are three techniques that can ...
     4  -1 2014 jul 16sql server errorlog fileHow to prevent enormous SQL Server error log files | SQL Server Question: Some of the SQL Server instances I manage routinely have extremely large (multiple gigabytes) error logs because they are ...
     4  ~ 2014 jul 16sms shortcut for expressTop Keyboard Shortcuts in SQL Server Management Studio Express SQL Server Management Studio Express (SSMSE) is the primary SQL Server Express management and development tool. Using keyboard ...
     5  +12 2014 oct 03business intelligence magazineBusiness intelligence information and tools for database administrators. Learn about ... Hybrid Business Intelligence with Power BI ... Digital Magazine Archives.
     5  +6 2014 oct 03sql server businessBusiness intelligence information and tools for database administrators. ... Services, SQL Server Integration Services, SQL Server Reporting Services, and more.
     5  +4 2014 oct 02sql server service managerStarting SQL Server - SQL Server MagazineThe SQL Server Service Manager applet can also start both local and remote servers as long as the remote server is registered in Enterprise Manager and you  ...
     5  +2 2014 oct 01sql report designerSQL Server 2008's Report Designer Preview | Reporting content This week, Derek discusses the Report Designer Preview feature that will be included with SQL Server 2008.
     5  ~ 2014 sep 30sql server developerSQL Server 2014 Developer Edition Licensing - SQL Server Magazine
    1 2 of 30 pages