Meta tags:
Headings (most frequently used words):
sql, services, server, editions, studio, data, service, and, management, microsoft, contents, history, supplemental, packages, architecture, storage, retrieval, programmability, see, also, references, further, reading, external, links, milestones, currently, mainstream, specialized, discontinued, buffer, concurrency, locking, native, client, snac, clr, agent, machine, learning, broker, replication, analysis, reporting, notification, integration, full, text, search, sqlcmd, visual, azure, business, intelligence, development,
Text of the page (most frequently used words):
the (371), sql (302), #server (278), and (176), microsoft (118), data (106), for (103), database (91), services (75), with (64), are (59), retrieved (58), can (54), edition (46), query (41), edit (40), which (40), studio (39), management (38), that (37), service (36), also (34), used (31), not (31), from (29), other (29), stored (29), 2007 (27), text (26), 2008 (26), windows (25), december (25), page (24), tools (24), search (23), system (23), index (22), 2005 (22), 2000 (22), includes (22), access (21), express (21), editions (21), net (19), version (19), using (18), client (18), visual (18), engine (18), reporting (18), replication (18), full (18), 2025 (17), software (17), memory (17), has (17), including (17), table (16), code (16), com (16), 2011 (16), analysis (16), support (16), available (15), released (15), databases (15), use (14), different (14), november (14), 2012 (14), storage (14), development (14), features (14), but (14), main (14), either (14), relational (13), azure (13), web (13), notification (13), row (13), types (13), september (13), pages (13), allows (13), queries (13), tables (13), enterprise (13), same (13), this (12), was (12), all (12), linux (12), business (12), intelligence (12), release (12), article (12), any (12), such (12), when (12), process (12), developer (11), basic (11), integration (11), clr (11), transaction (11), based (11), broker (11), they (11), will (11), standard (11), procedures (11), multiple (11), platform (10), history (10), native (10), application (10), provides (10), into (10), more (10), files (10), supports (10), defined (10), some (10), wikipedia (9), network (9), control (9), applications (9), object (9), concurrency (9), objects (9), file (9), machine (9), processor (9), words (9), out (9), their (9), time (9), called (9), sybase (9), about (8), foundation (8), systems (8), fast (8), 2022 (8), managed (8), language (8), july (8), architecture (8), buffer (8), size (8), operations (8), user (8), create (8), both (8), versions (8), its (8), each (8), then (8), these (8), sequence (8), changes (8), while (8), one (8), read (8), rows (8), locks (8), lock (8), toggle (7), mobile (7), view (7), statement (7), corporation (7), learning (7), list (7), manager (7), compact (7), what (7), msdn (7), functionality (7), single (7), supported (7), performance (7), 2016 (7), new (7), created (7), well (7), adds (7), over (7), via (7), columns (7), than (7), only (7), message (7), include (7), limited (7), after (7), does (7), shared (7), written (6), analytics (6), press (6), framework (6), ado (6), core (6), log (6), column (6), comparison (6), isbn (6), inside (6), introducing (6), april (6), overview (6), 2019 (6), xml (6), been (6), users (6), results (6), indexes (6), interface (6), execute (6), run (6), set (6), like (6), itself (6), subscriber (6), publisher (6), across (6), being (6), replaced (6), add (5), languages (5), statistics (5), terms (5), may (5), august (5), articles (5), february (5), networks (5), 2018 (5), xbox (5), unit (5), power (5), programming (5), servers (5), script (5), processing (5), model (5), plan (5), procedure (5), key (5), original (5), information (5), mining (5), snapshot (5), 2010 (5), track (5), plans (5), sqlcmd (5), introduced (5), execution (5), word (5), two (5), indexer (5), binary (5), component (5), performed (5), subscribers (5), designed (5), made (5), result (5), update (5), type (5), messages (5), along (5), operation (5), enhancements (5), unlike (5), have (5), retrieval (5), updated (5), identified (5), locking (5), structure (5), clustered (5), extent (5), subsection (5), contents (4), commons (4), website (4), wikidata (4), category (4), statements (4), english (4), games (4), learn (4), source (4), team (4), api (4), small (4), others (4), functions (4), odbc (4), partition (4), value (4), external (4), links (4), further (4), reading (4), docs (4), querying (4), discontinued (4), archived (4), agent (4), product (4), localdb (4), 2017 (4), specific (4), later (4), tool (4), runs (4), select (4), gui (4), many (4), command (4), exposes (4), rank (4), example (4), case (4), match (4), capabilities (4), part (4), sent (4), writing (4), accessed (4), configured (4), might (4), instance (4), contain (4), packages (4), proprietary (4), tasks (4), them (4), however (4), executing (4), connection (4), nodes (4), resource (4), allow (4), extension (4), back (4), number (4), cached (4), concurrent (4), processors (4), exclusive (4), cache (4), span (4), free (4), large (4), views (4), pack (4), parallel (4), embedded (4), 1989 (4), hide (4), move (4), sidebar (4), under (3), additional (3), registered (3), non (3), wikimedia (3), license (3), official (3), link (3), cs1 (3), media (3), studios (3), linkedin (3), high (3), 2009 (3), internet (3), explorer (3), 2006 (3), store (3), transact (3), pro (3), installer (3), msde (3), device (3), kit (3), apis (3), project (3), legacy (3), image (3), integrity (3), related (3), optimization (3), optimizer (3), components (3), cloud (3), oriented (3), 7356 (3), introduction (3), settings (3), library (3), connect (3), cannot (3), provider (3), merge (3), transactional (3), preview (3), driver (3), choosing (3), march (3), warehouse (3), end (3), evaluation (3), download (3), updates (3), environment (3), reports (3), general (3), prior (3), known (3), write (3), scripts (3), feature (3), within (3), among (3), schema (3), provide (3), included (3), managing (3), work (3), primary (3), executed (3), through (3), line (3), parameters (3), fts (3), uses (3), linguistic (3), divided (3), processes (3), unstructured (3), filter (3), daemon (3), once (3), specialized (3), character (3), 1000 (3), needs (3), warehousing (3), first (3), mechanism (3), notifications (3), event (3), send (3), report (3), protocol (3), exposed (3), algorithm (3), copy (3), entire (3), between (3), subset (3), security (3), defines (3), own (3), scale (3), started (3), session (3), running (3), tabular (3), metadata (3), named (3), runtime (3), most (3), operating (3), invoked (3), values (3), associated (3), name (3), necessary (3), resources (3), decides (3), contains (3), join (3), would (3), programmability (3), old (3), ensure (3), clients (3), currently (3), disc (3), heap (3), allocation (3), computer (3), cluster (3), space (3), map (3), maximum (3), tds (3), datacenter (3), intended (3), appliance (3), mpp (3), current (3), marking (3), topic (2), developers (2), safety (2), contact (2), privacy (2), policy (2), you (2), organization (2), inc (2), rendered (2), last (2), 2026 (2), categories (2), url (2), maint (2), deprecated (2), archival (2), targeting (2), containing (2), potentially (2), dated (2), 2023 (2), american (2), short (2), description (2), zenimax (2), technologies (2), labs (2), pixel (2), skype (2), entertainment (2), npm (2), devices (2), havok (2), github (2), company (2), transfer (2), fine (2), clipchamp (2), activision (2), blizzard (2), united (2), states (2), 2004 (2), 1994 (2), 2002 (2), where (2), today (2), stores (2), groups (2), build (2), technet (2), typescript (2), powershell (2), vbscript (2), vba (2), start (2), open (2), office (2), 365 (2), dynamics (2), laptop (2), hardware (2), employee (2), corporate (2), scott (2), hood (2), ceo (2), satya (2), nadella (2), people (2), outline (2), active (2), testing (2), foxpro (2), linq (2), communication (2), entity (2), dynamic (2), directx (2), cli (2), profiler (2), sdk (2), app (2), designer (2), macro (2), normalization (2), models (2), jdbc (2), trigger (2), unique (2), null (2), concepts (2), document (2), wikibooks (2), klaus (2), delaney (2), kalen (2), programmer (2), retiring (2), method (2), ssas (2), 978 (2), homepage (2), 2013 (2), june (2), reference (2), documentation (2), streaminsight (2), 2021 (2), trial (2), limit (2), scalability (2), requirements (2), january (2), cite (2), references (2), see (2), developing (2), solutions (2), controls (2), projects (2), ide (2), availability (2), cross (2), export (2), perform (2), act (2), visually (2), analyze (2), optimize (2), since (2), schemas (2), onwards (2), were (2), comes (2), received (2), breaks (2), filters (2), noise (2), variants (2), inverted (2), computed (2), returned (2), interact (2), creates (2), ifilters (2), hosted (2), occur (2), monitors (2), exe (2), searched (2), matching (2), string (2), range (2), higher (2), given (2), near (2), special (2), operators (2), various (2), three (2), methods (2), recent (2), installed (2), rdl (2), pdf (2), olap (2), modes (2), underlying (2), clustering (2), series (2), trees (2), tracked (2), synchronized (2), synchronization (2), manually (2), pre (2), master (2), who (2), side (2), encryption (2), format (2), queue (2), implemented (2), program (2), usually (2), routes (2), consists (2), following (2), tcp (2), python (2), allowing (2), without (2), scheduling (2), backup (2), common (2), automatically (2), added (2), top (2), redirected (2), hosts (2), connections (2), context (2), classes (2), internal (2), sqlos (2), rather (2), deadlock (2), base (2), implements (2), asynchronous (2), sets (2), stream (2), snac (2), creating (2), monitoring (2), manage (2), processed (2), possible (2), linked (2), print (2), instructions (2), because (2), need (2), cost (2), whether (2), low (2), actually (2), split (2), faster (2), concurrently (2), retrieving (2), variant (2), due (2), requested (2), actions (2), there (2), yield (2), optimistic (2), similar (2), moved (2), respective (2), levels (2), granularity (2), per (2), basis (2), leaves (2), level (2), less (2), dmvs (2), threads (2), acquire (2), grants (2), another (2), pessimistic (2), held (2), wait (2), buffered (2), how (2), complete (2), checksum (2), physical (2), partitions (2), numbered (2), order (2), spread (2), according (2), tree (2), leaf (2), storing (2), indexed (2), allocated (2), holds (2), share (2), those (2), varchar (2), makes (2), addition (2), collection (2), strings (2), symmetric (2), rounding (2), round (2), down (2), layer (2), initially (2), developed (2), protocols (2), samples (2), supplemental (2), logical (2), retired (2), personal (2), desktop (2), optimized (2), terabytes (2), massively (2), continue (2), starting (2), limitations (2), must (2), workloads (2), presented (2), offering (2), workgroup (2), xvelocity (2), mainstream (2), rtm (2), ghz (2), onto (2), milestones (2), ago (2), appearance (2), upload (2), bahasa (2), account (2), donate (2), menu (2), cookie, conduct, legal, contacts, disclaimers, apply, site, agree, trademark, profit, creative, attribution, sharealike, parsoid, edited, utc, hidden, unfit, hatnote, templates, nonexistent, mdy, dates, matches, https, org, php, title, microsoft_sql_server, oldid, 1369402327, yupi, yammer, appnexus, xandr, xamarin, winternals, webtv, vxtreme, volometrix, vivaty, visio, vermeer, undead, twisted, tellme, takelessons, swiftkey, sunrise, atelier, simplygon, riskiq, revolution, rare, proclarity, play, powerset, playground, placeware, perceptive, pando, onfolio, obsidian, nuance, communications, nokia, ninja, theory, mojang, metaswitch, massive, incorporated, maluuba, lionhead, linkexchange, jellyfish, inxile, hotmail, heat, major, league, baseball, group, groove, greenbutton, great, plains, giant, forethought, firefly, fasa, farecast, double, danger, consumers, connectix, compulsion, colloquis, bungie, blue, ribbon, soundworks, beam, azyxxi, aquantive, altspacevr, altamira, acquisition, acompli, 6wunderkinder, acquisitions, ftc, shah, alcatel, lucent, commission, mikerowesoft, lindows, 2001, apple, litigation, vista, _nsakey, bob, iloo, clippy, bundling, criticism, scroogled, mojave, experiment, champagne, want, campaigns, japan, india, campus, estates, retail, research, outercurve, garage, game, engineering, digital, crimes, divisions, winhec, pdc, mix, inspire, ignite, conferences, translator, outlook, msn, channel, copilot, bing, properties, mvpl, navision, attain, video, tay, teams, neo, hub, duo, surface, lifecam, hololens, kinect, products, unions, global, lgbtqia, allies, césar, cernuda, svp, richard, rashid, joe, belfiore, vps, cpo, kathleen, hogan, phil, spencer, harry, shum, clo, brad, smith, cto, kevin, cfo, amy, coo, carolina, dybeck, happe, guthrie, takeshi, numoto, cmo, senior, leadership, emma, walmsley, john, stanton, charles, scharf, carlos, rodriguez, penny, pritzker, sandi, peterson, mark, mason, catherine, macgregor, teri, hugh, johnston, reid, hoffman, chairman, board, directors, paul, allen, bill, gates, founders, package, wix, vcpkg, nuget, clickonce, setup, delivery, xunit, windbg, debugger, playwright, onefuzz, codeview, debugging, sourcesafe, delta, extensible, wdm, hlk, umdf, kmdf, wdf, wdk, drivers, workflow, presentation, identity, cardspace, maui, forms, razor, mvc, ajax, asp, winui, uwp, xna, silverlight, frameworks, xaml, vpl, verona, lean, ironruby, ironpython, jscript, javascript, java, dexterity, dafny, winrt, bosque, xamlpad, windiff, generator, ilasm, webmatrix, frontpage, sharepoint, roslyn, robotics, quickc, qbasic, quickbasic, pascal, msbuild, assembler, fxcop, expression, blend, environments, calculus, algebra, referential, federated, distributed, topics, sharding, administration, rewriting, xqj, dictionary, cursor, relation, surrogate, superkey, pacelc, design, principle, foreign, candidate, orientation, crud, cap, theorem, codd, rules, armstrong, axioms, acid, blockchain, multi, newsql, nosql, graph, wide, 2nd, book, elk, 7203, 5867, ben, gan, itzik, 2197, 2196, tuning, lance, delano, rajesh, george, 7645, 8923, wrox, starter, sqlmag, october, removed, render, rptproj, aschenbrenner, 1st, vienna, 4302, 0865, apress, blog, basics, extents, downloads, chapter, 2015, weblog, improved, home, increased, 10gb, licensing, datasheet, faq, 2105, compare, notes, installing, options, installation, guidance, center, lextrait, vincent, beacon, v10, latest, xleratordb, modeling, bids, utilizing, customized, extensions, structures, renamed, ssdt, cubes, editor, optional, commit, repositories, diagnostics, mac, git, central, browse, upon, observe, alter, existing, adding, modifying, configuring, administering, editors, graphical, replaces, ssmse, graphically, ssms, intellisense, debug, continued, 2014, predecessor, earlier, osql, isql, functionally, equivalent, pertains, identical, although, extra, versatility, prompt, during, deployment, scripting, handed, constituent, inbuilt, thesaurus, find, queried, against, accurateness, scans, extract, meaningful, blob, extracted, hands, etc, frequently, useful, remaining, associating, found, invokes, gatherer, msftesql, msftefd, indexing, operator, efficient, inexact, indicated, means, accurate, inflectional, verb, tense, lower, exact, proximity, searches, specified, considered, ssis, extracting, sources, transforming, aggregation, duplication, merging, exporting, transformed, destination, workflows, import, etl, originally, post, bundled, generating, driven, registers, occurs, informing, occurrence, smtp, soap, filesystem, longer, officially, 2003, variety, formats, excel, html, archive, tiff, png, jpeg, gif, emf, bmp, csv, builder, ssrs, generation, gathered, administered, custom, cube, algorithms, linear, logistic, neural, regression, naive, bayes, decision, dmx, mdx, holap, rolap, molap, publishes, replicates, periodically, directionally, modified, differently, conflict, resolved, policies, rowguid, synced, synchronizes, real, replicate, synchronize, entirety, present, agents, caches, follows, authentication, checking, authorization, certificates, kerberos, ntlm, plain, body, contract, conversation, put, acts, internally, insert, delete, receives, addresses, located, programs, queues, contracts, parts, communicates, exchange, reliable, messaging, queuing, analysts, configure, remote, push, executions, trained, scoring, operates, having, computers, come, distributions, commonly, science, microsoftml, revoscaler, revoscalepy, sqlagent, alerts, administrators, notified, email, typical, maintenance, backups, handling, subscriptions, performing, sub, restore, check, shipping, schedules, jobs, handles, automated, boots, assortment, essential, presents, accesses, doing, avoid, already, setting, parameter, several, consequence, datatype, xquery, true, integrates, threading, satisfied, detection, resolution, define, udt, persist, compiled, verified, relating, class, assemblies, triggers, natively, implementation, mirrored, receiving, plug, ins, directly, bypassing, generic, layers, ole, keywords, altering, entering, editing, consume, leverage, sending, errors, eval, loop, extend, instruction, manipulation, definition, ddl, dml, repl, procedural, parameterized, issued, accept, input, output, call, times, resolve, actual, every, reduces, traffic, somewhat, improves, selectively, provided, tries, take, looks, load, referred, should, selectivity, worthwhile, finally, costly, total, mean, generated, temporarily, invocations, unused, discarded, mode, expressed, dialect, shares, specifies, figures, steps, retrieve, ways, give, selecting, chooses, expected, shortest, declaratively, whenever, opposed, overwriting, additionally, maintained, though, requests, blocked, older, request, ids, tempdb, multiversion, applied, even, administrator, grained, simultaneously, requires, lightweight, latches, spinlocks, robust, intensive, busy, worker, takes, remedial, measures, cases, kill, entangled, roll, implement, maintains, manages, mediated, blocks, deadlocks, mutual, exclusion, attempt, changed, long, locked, latter, ram, minimize, disk, amount, copies, subsequent, reads, writes, referenced, whereby, done, background, thread, again, matched, damaged, tampered, meantime, buffers, default, providing, node, reachable, sorted, keys, unordered, indices, situations, advantages, heaps, units, sequentially, marked, byte, header, owns, contained, change, logging, uniform, mixed, exceeds, possibly, pointer, varbinary, composite, udts, virtual, bytes, exabyte, secondary, optionally, ldf, ndf, mdf, constraints, variable, length, textual, floats, integers, arithmetic, depending, arguments, gives, fix, blobs, char, decimal, float, integer, primitive, typed, communicated, 1984, packets, encased, transport, dependent, consequently, pipes, books, online, getting, guide, stress, read80trace, ostress, pssdiag, utility, best, practices, analyzer, packs, sqlxml, northwind, pubs, sample, published, featured, datacenters, 256, virtually, unlimited, premium, had, workload, limits, disconnected, proxy, licensed, working, did, admin, afterwards, wid, partnership, dell, datawarehouse, formerly, pdw, hundreds, aps, minimal, demand, specifically, 180, days, stop, specially, certain, ssee, test, production, early, charge, public, respectively, hand, binaries, dll, footprint, markedly, reduced, compared, batches, connectivity, proper, scaled, replacement, superset, capability, advanced, note, focusing, self, semantic, quality, pivot, option, hosting, tco, stand, alone, differs, fewer, instances, hot, still, 524, address, 640, cpu, cores, petabytes, onward, x64, minimum, recommended, big, clusters, intelligent, enhanced, experience, installations, platforms, docker, ubuntu, suse, red, hat, columnar, aka, hierarchical, filestream, spatial, finishes, revision, codename, shiloh, date, 1998, conversion, 1995, collaboration, independently, adaptive, 1993, entry, began, port, ashton, tate, begins, extends, day, entirely, descriptive, responds, bit, often, pronounced, sequel, function, markets, least, dozen, aimed, audiences, ranging, facing, structured, www, chinese, french, german, italian, japanese, korean, portuguese, brazil, russian, spanish, indonesian, months, stable, years, family, encyclopedia, item, printable, switch, parser, get, shortened, permanent, here, talk, tiếng, việt, українська, türkçe, ไทย, தமிழ், svenska, slovenčina, srpskohrvatski, српскохрватски, русский, română, português, polski, norsk, bokmål, nederlands, melayu, монгол, latviešu, 한국어, қазақша, 日本語, italiano, indonesia, հայերեն, hrvatski, हिन्दी, עברית, ગુજરાતી, galego, français, فارسی, español, ελληνικά, deutsch, dansk, čeština, català, български, azərbaycanca, العربية, community, portal, help, contribute, random, events, navigation, jump, content,
Text of the page (random words):
saction which is registered on the database server as a trigger when the event occurs notification services can use one of three methods to send a message to the subscriber informing about the occurrence of the event these methods include smtp soap or by writing to a file in the filesystem 59 notification services was discontinued by microsoft with the release of sql server 2008 in august 2008 and is no longer an officially supported component of the sql server database platform integration services edit main article sql server integration services sql server integration services ssis provides etl capabilities for sql server for data import data integration and data warehousing needs integration services includes gui tools to build workflows such as extracting data from various sources querying data transforming data including aggregation de duplication de normalization and merging of data and then exporting the transformed data into destination databases or files 60 full text search service edit the sql server full text search service architecture sql server full text search service is a specialized indexing and querying service for unstructured text stored in sql server databases the full text search index can be created on any column with character based text data it allows for words to be searched for in the text columns while it can be performed with the sql like operator using sql server full text search service can be more efficient full text search service allows for inexact matching of the source string indicated by a rank value which can range from 0 to 1000 a higher rank means a more accurate match it also allows linguistic matching inflectional search i e linguistic variants of a word such as a verb in a different tense will also be a match for a given word but with a lower rank than an exact match proximity searches are also supported i e if the words searched for do not occur in the sequence they are specified in the query but are near each other they are also considered a match t sql exposes special operators that can be used to access the fts capabilities 61 62 the full text search engine is divided into two processes the filter daemon process msftefd exe and the search process msftesql exe these processes interact with the sql server the search process includes the indexer that creates the full text indexes and the full text query processor the indexer scans through text columns in the database it can also index through binary columns and use ifilters to extract meaningful text from the binary blob for example when a microsoft word document is stored as an unstructured binary file in a database the ifilters are hosted by the filter daemon process once the text is extracted the filter daemon process breaks it up into a sequence of words and hands it over to the indexer the indexer filters out noise words i e words like a and etc which occur frequently and are not useful for search with the remaining words an inverted index is created associating each word with the columns they were found in sql server itself includes a gatherer component that monitors changes to tables and invokes the indexer in case of updates 63 when a full text query is received by the sql server query processor it is handed over to the fts query processor in the search process the fts query processor breaks up the query into the constituent words filters out the noise words and uses an inbuilt thesaurus to find out the linguistic variants for each word the words are then queried against the inverted index and a rank of their accurateness is computed the results are returned to the client via the sql server process 63 sqlcmd edit sqlcmd is a command line application that comes with microsoft sql server and exposes the management features of sql server it allows sql queries to be written and executed from the command prompt it can also act as a scripting language to create and run a set of sql statements as a script such scripts are stored as a sql file and are used either for management of databases or to create the database schema during the deployment of a database sqlcmd was introduced with sql server 2005 and has continued through sql server versions 2008 2008 r2 2012 2014 2016 and 2019 its predecessor for earlier versions was osql and isql which were functionally equivalent as it pertains to t sql execution and many of the command line parameters are identical although sqlcmd adds extra versatility visual studio edit main article microsoft visual studio microsoft visual studio includes native support for data programming with microsoft sql server it can be used to write and debug code to be executed by sql clr it also includes a data designer that can be used to graphically create view or edit database schemas queries can be created either visually or using code ssms 2008 onwards provides intellisense for sql queries as well sql server management studio edit main article sql server management studio sql server management studio is a gui tool included with sql server 2005 and later for configuring managing and administering all components within microsoft sql server the tool includes both script editors and graphical tools that work with objects and features of the server 64 sql server management studio replaces enterprise manager as the primary management interface for microsoft sql server since sql server 2005 a version of sql server management studio is also available for sql server express edition for which it is known as sql server management studio express ssmse 65 a central feature of sql server management studio is the object explorer which allows the user to browse select and act upon any of the objects within the server 66 it can be used to visually observe and analyze query plans and optimize the database performance among others 67 sql server management studio can also be used to create a new database alter any existing database schema by adding or modifying tables and indexes or analyze performance it includes the query windows which provide a gui based interface to write and execute queries 11 azure data studio edit azure data studio is a cross platform query editor available as an optional download the tool allows users to write queries export query results commit sql scripts to git repositories and perform basic server diagnostics azure data studio runs on windows mac and linux systems and is retiring on february 28 2026 68 it was released to general availability in september 2018 prior to release the preview version of the application was known as sql server operations studio business intelligence development studio edit main article business intelligence development studio business intelligence development studio bids is the ide from microsoft used for developing data analysis and business intelligence solutions utilizing the microsoft sql server analysis services reporting services and integration services it is based on the microsoft visual studio development environment but is customized with the sql server services specific extensions and project types including tools controls and projects for reports using reporting services cubes and data mining structures using analysis services 69 for sql server 2012 and later this ide has been renamed sql server data tools ssdt see also edit comparison of relational database management systems comparison of object relational database management systems comparison of data modeling tools list of relational database management systems xleratordb references edit release history for sql server 2025 on linux latest updates and version history for sql server lextrait vincent july 2010 the programming languages beacon v10 3 retrieved september 5 2010 cite web cs1 maint deprecated archival service link download microsoft sql server 2008 r2 microsoft evaluation center microsoft corporation retrieved july 18 2011 installation guidance for sql server on linux microsoft com december 21 2017 retrieved february 1 2018 what s new in sql server 2019 15 x microsoft com april 6 2022 retrieved may 11 2022 sql server end of support options learn microsoft com january 2 2025 retrieved january 18 2025 requirements for installing sql server 2016 docs microsoft com msdn microsoft com may 2 2016 retrieved july 28 2016 sql server 2022 release notes learn microsoft com retrieved november 21 2025 compare editions sql server homepage microsoft corporation retrieved december 3 2007 1 2 3 4 5 6 7 8 9 kalen delaney 2007 inside microsoft sql server 2005 the storage engine microsoft press isbn 978 0 7356 2105 3 sql server 2008 editions microsoft retrieved july 21 2011 database system performance scalability sql server 2012 business intelligence editions microsoft com retrieved june 15 2013 1 2 sql server 2012 licensing datasheet and faq march 2012 sql server 2008 r2 express database size limit increased to 10gb retrieved april 23 2010 what s up with sql server 2008 express editions retrieved august 15 2008 developer edition sql server home microsoft corporation retrieved july 18 2011 sql server 2008 trial software microsoft retrieved march 26 2009 microsoft sql server 2008 fast track data warehouse microsoft retrieved march 26 2009 sql server express localdb sql server microsoft docs retrieved august 2 2021 introducing localdb an improved sql express sql server express weblog microsoft docs july 12 2011 retrieved august 2 2021 microsoft analytics platform system microsoft retrieved april 29 2015 choosing an edition of sql server 2000 1 2 it pro features supported by the editions of sql server 2000 choosing a streaminsight edition msdn microsoft corporation retrieved july 18 2011 chapter 3 choosing an edition of sql server 2000 november 1 2010 archived from the original on november 1 2010 retrieved november 4 2022 sql server 2000 downloads sql server 2000 product documentation pages and extents retrieved december 2 2007 table and index organization retrieved december 2 2007 buffer management retrieved december 2 2007 single sql statement processing retrieved december 3 2007 stored procedure basics retrieved december 3 2007 transact sql reference retrieved december 3 2007 features of sql server native client retrieved december 3 2007 available today preview release of the sql server odbc driver for linux sql server team blog november 28 2011 retrieved june 15 2013 1 2 overview of clr integration retrieved december 3 2007 xml support in sql server retrieved september 5 2008 sql server agent page on microsoft developer network what is sql server machine learning services sql server homepage microsoft corporation retrieved april 10 2018 introducing service broker retrieved december 3 2007 1 2 3 klaus aschenbrenner 2011 introducing service broker pro sql server 2008 service broker 1st ed vienna apress pp 17 31 isbn 978 1 4302 0865 5 retrieved december 15 2019 types of replication overview retrieved december 3 2007 transactional replication overview retrieved december 3 2007 merge replication overview retrieved december 3 2007 snapshot replication overview retrieved december 3 2007 ssas entity framework provider archived from the original on september 29 2011 retrieved september 29 2011 analysis services architecture retrieved december 3 2007 data mining concepts retrieved december 3 2007 sql server reporting services retrieved december 3 2007 cannot open a sql reporting services rptproj file microsoft connect connect microsoft com archived from the original on february 3 2012 retrieved september 4 2011 msdn library reporting services render method device information settings image device information settings an introduction to sql server notification services september 3 2002 retrieved november 14 2008 sql server notification services removed from sql server 2008 archived from the original on october 16 2008 retrieved september 17 2008 discontinued functionality in sql server 2008 reporting services retrieved september 17 2008 introducing sql server notification services retrieved december 3 2007 integration services overview retrieved december 3 2007 introduction to full text search november 19 2007 retrieved december 3 2007 querying sql server using full text search retrieved december 3 2007 1 2 full text search architecture retrieved december 3 2007 msdn introducing sql server management studio msdn microsoft com retrieved september 4 2011 sql server management studio express microsoft com april 18 2006 retrieved september 4 2011 msdn using object explorer msdn microsoft com retrieved september 4 2011 sql server 2005 management tools sqlmag com july 19 2005 retrieved september 4 2011 what is azure data studio retiring docs microsoft com retrieved november 21 2025 introducing business intelligence development studio retrieved december 3 2007 further reading edit lance delano rajesh george et al 2005 wrox s sql server 2005 express edition starter kit programmer to programmer microsoft press isbn 0 7645 8923 7 delaney kalen et al 2007 inside sql server 2005 query tuning and optimization microsoft press isbn 0 7356 2196 9 ben gan itzik et al 2006 inside microsoft sql server 2005 t sql programming microsoft press isbn 0 7356 2197 7 klaus elk 2018 sql server with c isbn 1 7203 5867 2 external links edit wikimedia commons has media related to microsoft sql server wikibooks has a book on the topic of microsoft sql server official website 2nd official website at microsoft technet v t e database management systems types object oriented comparison relational list comparison key value column oriented list document oriented wide column store graph nosql newsql in memory list multi model comparison cloud blockchain based database concepts database acid armstrong s axioms codd s 12 rules cap theorem crud data orientation null candidate key foreign key pacelc design principle superkey surrogate key unique key objects relation table column row view transaction transaction log trigger index stored procedure cursor partition components concurrency control data dictionary jdbc xqj odbc query language query optimizer query rewriting system query plan functions administration query optimization replication sharding related topics database models database normalization database storage distributed database federated database system referential integrity relational algebra relational calculus relational model object relational database transaction processing list of sql software and tools category outline v t e microsoft development tools development environments visual studio code express team system profiler tools for applications tools for office others blend expression web fxcop gw basic macro 80 macro assembler msbuild pascal quickbasic qbasic quickc robotics developer studio roslyn sharepoint designer frontpage small basic webmatrix windows app sdk windows app studio windows sdk clr profiler ilasm native image generator windiff xamlpad languages dynamics ax basic visual basic legacy vb net vba vbscript bosque visual ...
|
